Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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?
Sorry, I don't know enough about Qlik Sense to give you an answer on that. Maybe someone else here can.