Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sayali_gajare
Contributor II
Contributor II

Date picker

how to calculate same period of the previous year  for which date range is selected from the calender.

1 Reply
vikasmahajan

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

 

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.