Comparing two data fields in qliksense

[qwerty89]

I want to compare two date fields in the set expression.

I am using the following expression -

count({<date_1={"=(date_1>date_2)"}>}date_1)

But it is giving me output as 0.

Any help here will be much appreciated.

[tresesco]

Syntactically the expression: count({<date_1={"=date_1>date_2"}>}date_1) looks fine. However, why you are getting 0, could not be be well guessed here. Could you share a sample app?

[qwerty89]

@tresesco 

I made the format same for both the dates but still it is not work.

I am working on a dummy app to try this out.

I have just inline load date_1 and date_2 and applied this expression.

To be more precise i am trying this out on the following table

Table:

Load * Inline

[

date_1,date_2

31/12/2010,31/10/2010

12/01/2018,14,01/2018

13/01/2017,14/01/2018

15/06/2017,21/01/2016

12/01/2019,14/01/2018 

];

[tresesco · Accepted solution]

I am getting this:

[qwerty89]

Appreciate your help.

Will try it out again.