Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.