topic Re: Show excluded values in a table in QlikView

Show excluded values in a table

kinjal1645 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have following table:

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.

Can you guys help me?

Thanks

Kinjal

Re: Show excluded values in a table

sunny_talwar — Tue, 24 Jul 2018 13:21:39 GMT

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)

Re: Show excluded values in a table

kinjal1645 — Tue, 24 Jul 2018 18:09:01 GMT

Perfect!

Thank you

Re: Show excluded values in a table

pintucs20 — Fri, 27 Jul 2018 11:19:34 GMT

Hi Kinjal,

Use all parameter in SET Analysis .