Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 )