topic Re: Comparing two data fields in qliksense in QlikView

Comparing two data fields in qliksense

qwerty89 — Wed, 13 Mar 2019 06:39:32 GMT

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.

Re: Comparing two data fields in qliksense

tresB — Wed, 13 Mar 2019 06:46:51 GMT

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?

Re: Comparing two data fields in qliksense

qwerty89 — Wed, 13 Mar 2019 07:45:20 GMT

@tresB

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

];

Re: Comparing two data fields in qliksense

tresB — Wed, 13 Mar 2019 07:51:01 GMT

I am getting this:

Re: Comparing two data fields in qliksense

qwerty89 — Wed, 13 Mar 2019 07:55:01 GMT

Appreciate your help.

Will try it out again.