Discussion board where members can get started with Qlik Sense.
Can any one please help me on below requirement.
In the below Month Year fitlerpane , could you please help me to show only Current year 2019 and Previous Year 2018 Related month Year values by take our 2017 Month year values in UI
If(Year(MonthYear)= 2018 or Year(MonthYear)= 2019, MonthYear,null())
then supress null
If you are looking for this year and last year data use year(today()) and year(today())-1 instead of hard coding 2018 and 2019
Thanks for your help.
I am looking dynamic solution. I need to use max(Year) and Max(Year)-1 all month years.
I struck at if logic syntax.
Please help me on this.