Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
pala_jagadeesh
Contributor III
Contributor III

Display common records from different fields

Hi,

How to display common records fro different fileds

All_Users users1 users2 users3
abc abc abc -
bcd bcd bcd -
cde - - cde
def - def def
efg efg - -

 

I want to create Button for user1 and when i click on Button its show result output like below

Resultant Output:

All_Users users1 users2 users3
abc abc abc -
bcd bcd bcd -
efg efg - -
Labels (2)
2 Replies
MendyS
Partner - Creator III
Partner - Creator III

hi

in the script you can write "If (len(users1)>0,1,0) as Flag"
and in set analysis filter that

pala_jagadeesh
Contributor III
Contributor III
Author

Thank you @MendyS