topic Re: How to pickup only last record per user distinct load in QlikView

How to pickup only last record per user distinct load

vikasmahajan — Mon, 30 May 2016 07:00:41 GMT

Dear all

I have following type of data user wise

So in QV load i want to show only single last row per user.

Thanks

Vikas

Re: How to pickup only last record per user distinct load

vikasmahajan — Mon, 30 May 2016 07:14:05 GMT

Actually user wise i want to create a list for last updated record for above case

E007569

Hecker,Jill Marie (E007569)

R295607

Praneet Jayaram

Terminated

201605

will be the o/p which is most recent record for this user.

Thanks

Vikas

Re: How to pickup only last record per user distinct load

vikasmahajan — Mon, 30 May 2016 07:15:28 GMT

This is only one user details i have so many users , per user i want to pickup only last updated record.

Vikas

Re: How to pickup only last record per user distinct load

Anonymous — Mon, 30 May 2016 07:22:07 GMT

Hi Vikas,

Have you tried with Max(charge_month) ?

Re: How to pickup only last record per user distinct load

tamilarasu — Mon, 30 May 2016 07:24:38 GMT

Try this,

Data:
LOAD user_sid,
     User_Name,
     [Manager SID],
     [Direct Manager],
     [Status in ID Vault],
     charge_month
FROM
[Book1 (1).xlsx]
(ooxml, embedded labels, table is Sheet1);

Inner Join(Data)
Load  user_sid,
     Max(charge_month) as charge_month
Resident Data
Group By user_sid;

Re: How to pickup only last record per user distinct load

MindaugasBacius — Mon, 30 May 2016 07:25:38 GMT

Try to use LastValue statement.

Re: How to pickup only last record per user distinct load

vikasmahajan — Mon, 30 May 2016 09:27:44 GMT

yes