Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
kinjal1645
Creator
Creator

Show excluded values in a table

Hello,

I have following table:

Capture.GIF

Requirement: When any IDS from primary table is selected, all IDS with same parameter combination should be displayed in separate table. (In below screenshot, IDS 9 is selected in primary table so in list box with IDS 2, 3 and 9 which have same parameter combination are displayed)

It is implemented through list box but I want it in a table with columns Team and IDS.

Since IDS will be excluded as seen in list box, I don't how to do show show excluded values in a table with above requirement.

Capture.GIF

Can you guys help me?

Thanks

Kinjal

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

May be use the same set analysis in your chart expressions

{1<

parameter1=p(parameter1),

parameter2=p(parameter2),

parameter3=p(parameter3),

parameter4=p(parameter4),

parameter5=p(parameter5)

>}


Capture.PNG

View solution in original post

3 Replies
sunny_talwar
MVP
MVP

May be use the same set analysis in your chart expressions

{1<

parameter1=p(parameter1),

parameter2=p(parameter2),

parameter3=p(parameter3),

parameter4=p(parameter4),

parameter5=p(parameter5)

>}


Capture.PNG

kinjal1645
Creator
Creator
Author

Perfect!

Thank you

pintucs20
Contributor III
Contributor III

Hi Kinjal,

Use all parameter  in SET Analysis .