Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Using variables in set analysis in Qlik Sense 3
Trying to plot graf limited from todays week and forward
Browsing the forum I found excellent tips that supposed to work but unfortunately they don’t
Defined the variable:
LET vWeekCurrent = Week(Today());
Formula:
Sum({$<Week={$(>vWeekCurrent)}>}([Amount 2015])
Don’t get it how to achieve greater than vWeekCurrent in the set
Data is two columns Week and Amount 2015
This works fine with
Sum({$<Week={“>27”}>}([Amount 2015])
may be like this
Sum({$<Week={">=$(=vWeekCurrent)"}>}([Amount 2015])
Thanks your proposal work, now.
Not sure why it did work from start