Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have a date Field as - (Period) in format of 'MMM-YYYY' . I need to only show last year data(2018).
How do i go with the script.
For Example -
Now i need to show only last year column, ie. 2018
Note: Period Field has auto calendar applied.
Thanks in advance.
you could do it with set analysis, but if you want to do it with the script:
- you could create a new field year inside calendar like this if(year(period)=Year(Today())-1,Year(Period)
- then use this field in the pivot
View solution in original post
Thanks a alot! It worked.