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: 
Alaeddin
Partner - Contributor
Partner - Contributor

qlik sense comparison between range of dates

Hello, 



i want the calendar to select two range of dates to compare them for sales 

 

but in the sheet i keep getting same data for the overall for last year and this year 
and 0 for last year in month to date 
 

i want a fix for this so i can select two (range ) dates like a holiday week in apr 2022 and holiday week in apr 2023

 

 

( have this for date in data load  ) 

date(Date#(Date,'DD-MMM-YYYY')) as Date,Year,
Month,
Day,
DateNum,

2 Replies
Chanty4u
MVP
MVP

First date range 

Sum({<Date = {">=$(vStartDate1)<=$(vEndDate1)"}>} Sales)

second date range 

Sum({<Date = {">=$(vStartDate2)<=$(vEndDate2)"}>} Sales)

 

Alaeddin
Partner - Contributor
Partner - Contributor
Author

hello thanks for the reply ,

how can i use this in date picker( calendar )