806 questions
0
votes
0
answers
46
views
Period over period line chart using qlik sense
I have a line chart where I have my order date on dimension and the total sales as a measure. When I choose for example date range as jan 8 to 14.which will give me the daily sales on line chart ...
- 45
0
votes
0
answers
59
views
Issue Migrating IntervalMatch() from QlikView to Qlik Sense — Only Field Names, No Data Returned
I'm migrating a QlikView app to Qlik Sense, and I'm running into an issue where a script using IntervalMatch() stops returning data in Qlik Sense, even though it works perfectly in QlikView.
✅ Context
...
- 3
0
votes
1
answer
44
views
Looping Through to Create Alias Name Qlik
I am having an issue creating an alias name while looping in qlik sense. Below are my 2 code versions both not successful, nothing wrong with the joins or resident tables.
Version 1
// Define an array ...
- 112
0
votes
0
answers
60
views
Qlik Sense Dense Rank in Set Analysis not Load Editor
I currently have a rank(sum(sales),0,1) and it is showing as the rank column but I want it to show like the ideal rank column. I would like to do it in set analysis not in the dataload editor, I ...
- 112
1
vote
1
answer
81
views
Qlik Cli Connection Problem in Qlik Sense Environment
My goal is to analyze Qlik files in the Qlik Sense environment. I want to extract all the app's dimensions, measures, scripts, charts etc in our environment. And I will create a report that shows ...
- 11
0
votes
0
answers
122
views
Qlik Sense not writing data to s3 location
I have a requirement where I want to store a csv and qvd file generated in Qlik sense in a S3 location. I have successfully created a S3 connection from where my script can also read from files. ...
- 81
0
votes
1
answer
116
views
Qlik - Need help creating a calculated field that contains a sum of some of the values in another column
I have a data set that looks like this:
Column A
Column B
Column C
Q1
1743
382
Q1
1376
Q2
1599
419
Q2
1283
And my goal is to create a calculated field that takes the number in Column C and divides it ...
1
vote
1
answer
353
views
Filtering Qliksense dates by using buttons
I need to create a way to quickly filter dates 1 year before now, 6 months before now, 1 month before now, 1 week before now, etc. Buttons looks to be the best option. Looked into Date Picker, but to ...
- 619
0
votes
0
answers
161
views
Airflow 2.10.3 how to extract information about task instances?
I use Airflow 2.10.3 and I'd like to retrieve informations about when a task starts, ends, its status (e.g. success, fail) and similar attributes.
I found a PostgreSQL database with all the list of ...
- 275
0
votes
1
answer
86
views
Create a QLIK Data connection of type Amazon S3
My requirement is to create Data connections in QLIK of type S3 for which I need to make use of QLIK API for automation. I am not able to form the payload properly for this requirement. Getting 400 ...
- 21
-2
votes
1
answer
91
views
Qlik expression to DAX expression conversion
I need help in converting Qlik sense expression into a DAX expression.
Qlik sense expression:
if(sum(Total <AssociateEmail,RatingManager>{<flag_skill={1}>}RatingManager)>0, 'Initiated', ...
-1
votes
1
answer
298
views
Is it possible to execute an EXECUTE command from QLIK SENSE to open a VBS file that behaves like a BAT file?
I have this code in VBS that when I double click on it, it opens a URL link for me:
Option Explicit
' Declare variables
Dim url, shell
' Set the URL you want to open
url = "https://pa-qliksense....
- 19
-1
votes
1
answer
100
views
Equivalent Function between Qlik and PowerBI
I am doing migration report from Qlik to PowerBI.
I am wondering how to change this Qlik function into PowerBi.
=Num(Count(distinct {1 <[Type]-='Other',SaleDate=P(MasterCalenderDate)> } [...
- 4,588
1
vote
1
answer
53
views
Reuse expression in QlikSense
I have a lengthy expression like this:
$(vUseHotlist) * number_of_bids_from_hotlist +
$(vUseStocklist) * number_of_bids_from_stocklist +
$(vUseDashboard) * number_of_bids_from_dashboard
I want to ...
- 1,057
0
votes
1
answer
55
views
Qlik Sense not totalling several measures despite being numeric
I have a table with several measures. Only one of them is being totalled in the table:
I have checked the data model viewer and all measures are numeric (and could be summed I asume). However, only ...
- 359
0
votes
1
answer
219
views
how to limit the line chart dimension for only past 12 months and each month should show summation of past 12 months to that particular month
I have to create a qliksense line chart with dimension which shows only past 12 months from current date as dimension and measure should be rolling 12 month summation of past 12 months to that ...
1
vote
1
answer
247
views
Can I export a PDF file from the QLIK SENSE API not through a link but directly so that a PDF file with the desired sheet will be attached?
I manage to export from the QLIK SENSE API sheets by sheet and application IDs, but first of all I have to click on a link that leads me to download the PDF file, I was unable to cancel the action of ...
- 19
0
votes
1
answer
302
views
How to Use Date range in SET Analysis, yet ignore a Date selection
I have a table where currently the date dimension [Fiscal Week End Date] is selected.
However, for a given selected date, I would need to display for a record the sum of [Sellin Quantity] between [...
0
votes
1
answer
85
views
How can I extract a Qlik app layout/structure as JSON directly from Qlik cloud?
What is the simplest way to get the structure/layout of my Qlik dashboards in the form JSON files in Qlik Cloud? So it should contain detailed informaions about visualizations & styles.
I can ...
0
votes
1
answer
100
views
Pulling a table Chart from An App in QlikCloud Using Python
I am trying to pull a table chart from Qlik Cloud and convert to Panda Dataframe in my Jupyter Notebook.
I tried the below code, it was able to connect and read from an App but could not pull the ...
- 11
0
votes
1
answer
173
views
Update QLIK Data Connection of type Amazon S3 with new IAM Access key and Secret Key using QLIK Rest API
I have a requirement to update QLIK Data connection of type Amazon S3 using QLIK API through an automated script.
We rotate our IAM access keys every 90 days. So, we have to update our QLIK Amazon S3 ...
- 21
1
vote
1
answer
85
views
How to create a measure in QlikSense to count distinct equipment sending signals within a dynamic date range
I'm working with a dataset in QlikSense that tracks daily equipment signal data. Each record includes the equipment ID (serial_number), the date the signal was sent (created_on), and the date the ...
- 11
-1
votes
1
answer
238
views
Replace SimpleFieldSelect with Variable input on Dual Function
I am trying to replace the SimpleFieldSelect extension with Qlik's Variable input but am not able to get the Dual function to work properly to display those inputs.
Below is the dual function used in ...
- 112
0
votes
1
answer
73
views
Using part of table title in set analysis expression Qlik Sense
Is it possible to use/refer to a part of a table (in a dashboard) title in a set analysis expression in Qlik Sense?
Like I want to use the last 3 characters from the table title for example to use in ...
- 359
0
votes
1
answer
205
views
How to pass authentication token to websocket call in QlikSense
I am creating a simple mashup and it generates below config --
var config = {
host: window.location.hostname,
prefix: prefix,
port: window.location.port,
isSecure: window.location.protocol === "...
- 3,761
0
votes
1
answer
95
views
Set Analysis to Iterate Over Two Fields that Are Equal to Each Other
I am trying to return a table with FieldA and a measure that returns the count of FieldC where FieldA = FieldB divided by the total count of FieldC (no issue with the denominator).
Below measure works ...
- 112
0
votes
1
answer
70
views
Calculating a measure on all rows based on a subset of the data
I have a dataset containing data like following:
Customer
invoice number
invoice date
payment date
payment_days
open_flag
Customer 1
invoice 1
1/1/24
10/1/24
9
no
Customer 1
invoice 2
1/1/24
20/1/24
...
- 15
2
votes
1
answer
181
views
Unable to get comma separated values in Qlik text box for a certain logic
I want a comma separated value in a qliksense text box.
Consider the following data
REGION|MARKET|METRIC|VALUE
ASP|INDIA|S1|1
ASP|CHINA|S1|0
ASP|INDIA|S2|0
ASP|CHINA|S2|1
ASP|HONGK|S1|1
EUR|UK|...
0
votes
1
answer
139
views
Compare the data sets coming from two set expression in Qliksense
I have a data set in the columns as follows:
Reporting Month
Object ID
Flag
Flag column can have values as 1 or 0. Reporting Month column has data for May & June.
I want the list of all Object ID ...
0
votes
1
answer
442
views
Qlik left join to the same table - how it works in SQL?
I have such a tranformation in Qlik
abc:
SELECT distinct
AA.ACCOUNT_ID AS ACCOUNT_ID_AA,
AA.ID AS ID_AA,
AA.F_a AS F_a_AA,
AA.F_b ...
- 195
1
vote
0
answers
103
views
ETL Error: Receipt Process Fails to Fetch Data Despite Successful Reruns - Need Insights
I've been experiencing issues with my ETL for the past few months consistently. Our ETL is scheduled to run every 12 AM. I've noticed in one of our tables,
[logs]
[4/2/2024 12:14:14 AM][QLICKSENSE-1][...
- 11
1
vote
0
answers
216
views
Qlik - How to get list of assigned Space / Fetch all Apps of an Space / Fetch all Sheets of an App using REST API
I am working on a project, where I integrated Qlik by embedding the Qlik Apps and Sheets on my website. So the flow of my website is like below:
User visit my site, logged in and authenticate with ...
- 1,285
0
votes
1
answer
222
views
Count Number of Occurrences Before Specific Field Then Reset
In either the Data Load editor or a measure in a table in Qlik Sense I am trying to count the number of distinct results for each UserID before the Result = "Cat" occurs.
Source Table
UserID
...
- 112
0
votes
1
answer
201
views
Integration AD B2C x QlikSense for Windows using OIDC
Is there any article showing how to integrate Qlik Sense for Windows with Azure AD B2C? I'm trying to do an authentication using OIDC but I'm receiving:
400 Contact your system administrator. The user ...
- 1,012
0
votes
1
answer
847
views
How to write row_number with partition by in qlik table?
I want to write below row_number logic in qlik table. How can it be written?
row_number() over (partition by job.jobnumber order by cast(hist.EventTimeStamp as Date) asc) as row_id
How to write ...
- 11
0
votes
1
answer
426
views
How can i get a Qlik app layout as XML/JSON File?
What is the simplest way to view the structure/layout of my Qlik dashboards in the form of XML or JSON files in Qlik Sense Desktop?
So it should contain detailed informaions about visualizations & ...
- 3
1
vote
0
answers
579
views
How to embed Qlik App/Sheet on the website
I want to embed Qlik app/sheet on my website. There are apps on the Qlik, and the apps contains the sheets, which I want to embed for showing to website visitors/user. But users don't have access of ...
- 1,285
0
votes
2
answers
136
views
Rename Qlik Sense Sheets using API
I am trying to rename Qlik Sense Sheets using APIs. I got to know we should rename only using properties. I tried below code in Powershell but its not working. Please help me correct the code. I am ...
- 135
1
vote
1
answer
119
views
Expression filtering based on user input
I wish to aggregate Score * Revenue for the most recent entry per organization, considering only those entries where the date is less or equal to a user-defined variable vSelectedDate that is from the ...
- 13
0
votes
1
answer
574
views
how to choose one value from a columns in "show column if" is qliksense
I am trying to use the Only function in qliksense in order to pick only 1 value from a column to show. It's keeps showing all values. I also tried using Match along with GetFieldSelections.
The code:
...
- 301
0
votes
1
answer
116
views
Is it possible to run an HTML file that is in Mash up outside of Mash up?
I have this html code that I put in the Qlik sense hub:
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="X-UA-Compatible" content="IE=edge,...
- 1
0
votes
1
answer
151
views
What is the alternative of PEEK() function in Qlik in ATHENA AWS?
I'am looking to increment the current calculated value as a field in Athena AWS, that is possible in Qlik with peek() function, the goal is to create and increment the state field in each investor or ...
- 43
0
votes
1
answer
406
views
Qlik Sense: loading tables with filter
This is my load script:
All:
load *;
sql exec [StoredProcedure];
LastYear:
load *
resident All
where Ship_Year = year(now())-1;
ThisYear:
load *
resident All
where Ship_Year = year(now());
However, ...
- 593
0
votes
1
answer
417
views
Qlik sense: filtering to look at "previous year"
I'm wanting to filter my dataset to look at last year (dynamically) in the expression field of my measure. When I use the following code, it errors out:
Sum({<Ship_Year = {Year(now())-1}>}...
- 593
-1
votes
2
answers
719
views
Is there a way send email dynamically from email list table through Qlik Nprinting
I am working on requirements, where I have created a flat table in qlik sense frontend, and table is as below:
Email To
Email CC
Status
[email protected]
[email protected]
stopped
[email protected]
[email protected]
...
0
votes
1
answer
666
views
Qlik Sense - Possible to freeze column in Straight table
Chart exploration in Straight table allows users that do not have edit rights to customize the original straight table when they are in analysis mode. These users can add or remove columns as they ...
- 171
0
votes
1
answer
559
views
Qlik Sense Aggregate and compare values in two fields
In Qlik Sense (charts only) I need some help to identify and calculate occurrences for each ID where values in CODE_A does not match the values in CODE_B.
Based on my example data, I want a straight ...
0
votes
1
answer
349
views
Qliksense: making column height dynamic rather than static
In my dataset, there is a STUFF() function that is combining multiple values into one string separated by a comma. The problem is that unless I adjust the row height, values are getting cut out. So ...
- 593
0
votes
1
answer
705
views
QlikView/QlikSense: Transforming Column with Lots of Strings
I have the following structure as input in Qlik, comprising two columns. The first column (index) contains sequentially increasing numbers, while the second column, which requires transformation, ...
- 420
0
votes
1
answer
353
views
QlikSense - retrieving row values outside of the current filter selection
I'm trying to create an expression that will retrieve values outside of the user's selection, and at a certain level. My fact table is stacked with multiple fact tables, an example of the data model ...
