Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to calculate same period of the previous year for which date range is selected from the calender.
Create variable for CY date & PY Date assign this variables to date picker CY & Date Picker 2
use this variables in set analysis like:
Sum({1<[Order Date]={">=$(=Date($(vFromDate)))<=$(=Date($(vToDate)))"}>}[Sales])
refer full link for the same:
https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-create-Date-Picker-in-Qlik-Sense/td-p/1172549
Hope this help you
Vikas