topic Comparision of Date fields in QlikView

Comparision of Date fields

Wed, 25 Nov 2020 16:16:04 GMT

Table1:

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:

Kushal_Chawda — Fri, 03 Jun 2016 06:57:35 GMT

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

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

Fri, 03 Jun 2016 07:19:42 GMT

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.