Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.