topic Flag is not getting created correctly when comparing two dates?? in QlikView

Flag is not getting created correctly when comparing two dates??

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am very new to qlik please suggest me something for the below issue:

I need to create a flag containing values Y and N.

I have created these two columns Date and Latest Date from csv file Date_key column and saving in qvd file.

my code is like this:

Date Latest Date Flag

22/08/2016 22/08/2016 Y

23/08/2016 22/08/2016 N

24/08/2016 22/08/2016 N

25/08/2016 22/08/2016 N

and the i am using the below code to create the flag

Load

if(Date = Latest Date,'Y','N') as MaxDate

Resident Dummy;

Thanks in Advance.

Re: Flag is not getting created correctly when comparing two dates??

Wed, 07 Dec 2016 16:07:45 GMT

Hi,

Its output is coming like this:

Date Latest Date Flag

22/08/2016 22/08/2016 Y

23/08/2016 22/08/2016 N

24/08/2016 22/08/2016 Y

25/08/2016 22/08/2016 N

which is not correct.

Re: Flag is not getting created correctly when comparing two dates??

MK9885 — Wed, 07 Dec 2016 16:33:20 GMT

Isn't that correct?

You wanted Y or N as flag.

You have condition placed as well...then what more you need?

You want Min & Max or Flag?

Re: Flag is not getting created correctly when comparing two dates??

Aurelien_Martinez — Wed, 07 Dec 2016 16:49:34 GMT

Hi,

My script :

LOAD

If(Date = [Latest Date], 'Y', 'N') as tt,

Date,

[Latest Date]

INLINE [

Date , Latest Date

22/08/2016, 22/08/2016

23/08/2016 , 22/08/2016

24/08/2016 , 22/08/2016

25/08/2016 , 22/08/2016

];

And the result :

Date	Latest Date	tt
22/08/2016	22/08/2016	Y
23/08/2016	22/08/2016	N
24/08/2016	22/08/2016	N
25/08/2016	22/08/2016	N

Aurélien

Re: Flag is not getting created correctly when comparing two dates??

Fri, 09 Dec 2016 10:20:20 GMT

Hi all,

Thanks for your replies.

have got the solution for it.

i am creating a temp table to find out the max date:

RecentWeekvalue:

Load

Date(max(weekendDate), 'DD/MM/YYYY') as RecentWeek

Resident Calendar;

store this value in variable:

we need to use peek because it will get the first value from max.

let vRecentWeek =Peek('RecentWeek',0,'RecentWeekvalue');

and then compare it :

and important is keep your variable in single quotes only then it will work:

IF (weekendDate = '$(vRecentWeek)','Y','N') as MostRecentWeek,

Thanks all for the solutions.