topic Re: Date Comparision in QlikView

Date Comparision

Imrat — Wed, 17 Apr 2019 07:31:18 GMT

How do i compare two dates with additional condition in set analysis, i tried the following but seems to be i am missing something.

Basically what i am trying to do is taking count of status, if completion date is greater than due date.

=count( {<[Completion Date] = {">$([Due Date])"},Status={'Closed'} > } Status)

Many thanks in advance

saminea_ANZ — Wed, 17 Apr 2019 09:05:07 GMT

May be this?

=count( {<[Completion Date] = {"=[Completion Date]>[Due Date]"},Status={'Closed'} > } Status)

Imrat — Wed, 17 Apr 2019 09:12:06 GMT

i tried this , count is zero

saminea_ANZ — Wed, 17 Apr 2019 09:21:02 GMT

Can you please create one more field in script as

Load *, If([Completion Date]>[Due Date], 1,0) as Flag;

and the expression like

=count( {<Flag = {'1'},Status={'Closed'} > } Status)

Imrat — Thu, 18 Apr 2019 05:26:08 GMT

Many thanks,

it worked like a charm.