806 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
47
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 ...
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
...
0
votes
1
answer
45
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 ...
0
votes
0
answers
62
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 ...
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 ...
0
votes
0
answers
124
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. ...
0
votes
1
answer
118
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
360
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 ...
0
votes
0
answers
164
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 ...
0
votes
1
answer
87
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 ...
-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
304
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....
-1
votes
1
answer
101
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)> } [...
1
vote
1
answer
55
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 ...
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 ...