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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
qwerty89
Contributor III
Contributor III

Comparing two data fields in qliksense

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.

 

 

 

1 Solution

Accepted Solutions
4 Replies
tresesco
MVP
MVP

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
Contributor III
Contributor III
Author

@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
MVP
MVP

I am getting this:

Capture.PNG

qwerty89
Contributor III
Contributor III
Author

Appreciate your help.

Will try it out again.