topic Re: Select excluded in QlikView

Select excluded

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

i want to exclude the selections in the list box

example

i have a list box if i select any value in that those values should not appear in the straight table

in that straight table have two expressions those all are count only

vishsaggi — Mon, 08 Oct 2018 15:50:32 GMT

What is your straight table expr? May be you can try like

Change ID with the field name your are using for Count.

= Count({$< ID = E({$}ListboxName) >}ID)

manoj217 — Mon, 08 Oct 2018 15:59:47 GMT

initially i want to show all values

above expression initally not showing any data but while selecting any values it is excluded of those

vishsaggi — Mon, 08 Oct 2018 16:07:03 GMT

May be try like below:

= IF(GetFieldSelections(ListboxName)>0, Count({$< ID = E({$}ListboxName) >} ID), Count(ID))