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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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))