Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis Expressions - Inputs from Filter Applied

I have the below set analysis expression which calculates the Sum of Sales for the Reporting Date 31-Dec-2013.

sum({$<[Reporting Date] = {'31/12/2013'}>} [Sales])

In this I have hardcoded the value 31-Dec-2013. Instead, I need to define this expression, where the Date comes as input from a Filter selection that the user makes.

If user selects 31-Jan-2014, it should be computed for this date. Is there a way to make the expressions generic and receive inputs based on user selections?

22 Replies
Anonymous
Not applicable
Author

It sounds like you would want to use 2 Slider/Calendar object to populate variables.  One for a start date and one for the end date

(You can get the the object to be a date pick list.)

Then you would just use the variables tied to the objects in your set analysis.

Similar to this Selecting Arbitrary Date Ranges.

Not applicable
Author

I have taken a look at the video. Yes. Some thing like this. The video shown is in Qv I believe. Can we do the same in QS? 2 Slider/Calendar is an external object or can this be built within QS?

Anonymous
Not applicable
Author

Sorry, I don't know enough about Qlik Sense to give you an answer on that.  Maybe someone else here can.