Solved: How to pickup only last record per user distinct ... - Qlik Community

vikasmahajan · ‎2016-05-30

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

tamilarasu · ‎2016-05-30

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;

View solution in original post

vikasmahajan · ‎2016-05-30

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2016-05-30

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

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Anonymous · ‎2016-05-30

Hi Vikas,

Have you tried with Max(charge_month) ?

tamilarasu · ‎2016-05-30

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;

MindaugasBacius · ‎2016-05-30

Try to use LastValue statement.

vikasmahajan · ‎2016-05-30

yes

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

How to pickup only last record per user distinct load