Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
D19PAL
Creator II
Creator II

Compare numbers two dates, using date picker?

Hi,

I got two date fields in the same data set, one called date1 and the other called date2.

I got two date pickers (can have one if possible) one for date1 and the other for date 2.

 

In a table,  I want to calculate  the sales  for date1 and date2 in the same table.  When I pick one or the other now, they are over ridding each other.  for example I want 13/06/2022 to say 10 and 13/06/2023 to say 5.

Data

Sales : Date

10, 13/06/2022

5,13/06/2023

 

In table

Date1 Sales : Date2 Sales

10, 5

 

Thanks 

 

 

Labels (4)
1 Reply
D19PAL
Creator II
Creator II
Author

I've sorted it out using alterate states