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: 
Not applicable

Comparision of Date fields

  Table1:  

Date1Date2IDcomment
26/05/201626/05/2016200Test
27/05/201627/05/2016300Test
8/8/20168/8/2016100Test
10/10/201610/10/2016400Test
10/12/201610/12/2016500Reject
10/13/201610/12/2016500Reject

Date1 as a dimension
Expression:Count({<where comment = Test,Date1 greater than (Date2 - 60)>} Distinct ID)

Please help me in writing the above set expression to get the below output:

 

  Output:  

Date1Date2IDcomment
5/26/20165/26/2016200Test
5/27/20165/27/2016300Test
8/8/201611/8/2016100Test

 

2 Replies
Kushal_Chawda

Assuming that Your dates are properly formatted (i.e not string)

=Count({<comment ={'Test'}, Date1={"=Date1>Date2-60"}>} distinct ID)

Not applicable
Author

Hi,

As per the condition what you are telling you will get all Test cases.

But your output contains 3 cases only.

Is there any other conditions.