topic Re: same date and key with different data for in QlikView

same date and key with different data for

manoranjan_d — Tue, 05 Jul 2016 11:37:33 GMT

Hi,

when i try to create flag for the max date its not creating for the situation of same multiple date and same key

can i ksolve this issue

KEY	DATE	AMT	YEAR_FLAG	Year
key1	06012016	100		2016
key1	06012016	200		2016

Re: same date and key with different data for

manoranjan_d — Tue, 05 Jul 2016 16:37:30 GMT

can any one reply me to my query

Re: same date and key with different data for

vinieme12 — Tue, 05 Jul 2016 16:49:06 GMT

Please Post your expression you are trying to create the Flag with.

also you need to reformat your date field

Re: same date and key with different data for

santiago_respane — Tue, 05 Jul 2016 17:10:10 GMT

Hi!

How are you trying to create the flag?

Please elaborate more in order to be more helpful.

Kind regards,

Re: same date and key with different data for

manoranjan_d — Wed, 06 Jul 2016 04:02:07 GMT

FACT:

KEY,

DATE,

AMT

FROM

XXXX;

YEAR:

LOAD

Distinct

FirstSortedValue(KEY,-DATE) as KEY,

date(Max(DATE),'YYYY') as YEAR,

'Y' as YEAR_FLAG

Resident FACT

Group By KEY

;

now in the chart if i use the expression as

expression 1:

if(GetSelectedCount(Year)>=1,sum({< YEAR_FLAG={'Y'}>}AMT)

expresion2:

if(GetSelectedCount(Year)>=1,count({< YEAR_FLAG={'Y'}>}KEY)

Re: same date and key with different data for

manoranjan_d — Thu, 07 Jul 2016 04:22:27 GMT

can any one reply me

Re: same date and key with different data for

PrashantSangle — Thu, 07 Jul 2016 05:10:17 GMT

Hi,

what is your expected output??

Regards

Re: same date and key with different data for

PrashantSangle — Thu, 07 Jul 2016 05:23:51 GMT

Hi,

Are you looking for below output

There might be multiple solution one of it below

Test:

LOAD * INLINE [

Key, Date, Amt , Year

key1, 06012016, 100, 2016

key1, 06012016, 200, 2016

key2, 06022016, 200, 2016

];

join

Load Key as Key,

Date as Date,

max(Amt) as Amt,

Year as Year,

'maxFlag' as Flag

Resident Test

group by Key,Date,Year;

Regards,

Prashant