Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I am pretty new to Qlik Sense and took over an assignment to do some adjustment on a dashboard.
The dashboard I am working on have two other Date selection buttons YTD and YTM. The action for YTD defined as
=IF($(vSel_CY) = YEAR(TODAY()),
'<=' & num(month(addmonths(today(),0))),
'=' & num(month(addmonths(today(),0)))
And the YTM is also something similar à '<=' & num(month(addmonths(today()-30,0)))
Was wondering how could I modify the formula in a way that it shows the full year with all months selected ?
or maybe should i use pick function instead??
NB: Field defined for button is [Date.Cal.Month]=["JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC"]
Hi, if the dates filter s are based on 'Today()' it would be better if you add a master calendar with flags,as an example: https://community.qlik.com/t5/QlikView-App-Dev/Master-Calendar-Flags/m-p/1279747
This whay you oly need to change set analysis like:
Sum({<$(VariableValue),Year,Month>} Sales)
And each button changes VariableValue to: CurMTDFlag={1} or CurYTDFlag={1}