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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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.