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

Select excluded

Hi

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

3 Replies
vishsaggi
Champion III
Champion III

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
Creator III
Creator III
Author

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
Champion III
Champion III

May be try like below:

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