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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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