topic Re: Qlikview in QlikView

Qlikview

kunal-rai — Sat, 16 Nov 2024 19:28:22 GMT

if user in multiple groups and we have group priority then how can we remove it from other group based on priority

User table

UserId, Groupid

aaa ggg

aaa bbb

ccc hhh

ccc bbb

priority group tbl

ggg 1

bbb 2

hhh 3

result would be

UserId, Groupid

aaa ggg

ccc bbb

How do we achieve ?

Re: Qlikview

lfetensini — Thu, 12 Dec 2019 16:08:38 GMT

You need create a "number" property in your GroupId and get only the MIN. Then the field will have two values: number and text. Like "month" or other "date" fields.

T1:
LOAD * Inline [
UserId, GroupId
aaa, ggg
aaa, bbb
ccc, hhh
ccc, bbb
];

Left Join (T1)
LOAD * Inline [
GroupId, Priority
ggg, 1
bbb, 2
hhh, 3
];

Table:
LOAD
UserId,
MinString( Dual(GroupId, Priority) ) as GroupId
Resident T1
Group By UserId;

Drop Table T1;

Re: Qlikview

Brett_Bleess — Wed, 18 Dec 2019 20:05:18 GMT

Did the post help you with your use case? If so, do not forget to return to things and use the Accept as Solution button on the poster's thread to give them credit for the assistance and let other Community Members know things worked. If you are still trying to sort things out, please leave an update with what you still need.

Regards,
Brett