Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
kushalthakral
Creator III
Creator III

Ignore one list box while showing data in a table

Hi All

I have requirement where i need to show some data in a table where i have to exclude selections made in one of the list box but table should respond to other list boxes when user selects anything in that

Regards

Kushal Thakral

5 Replies
marcus_sommer

You could use set analysis for it, try something like this:

sum({< YourListboxField = >} Value)

- Marcus

kushalthakral
Creator III
Creator III
Author

Hi

I want to apply this to the entire table

Regards

Kushal Thakral

marcus_sommer

If you used an expression like above mentioned the table-chart will ignore any selections which are made within these field - the important point is to use a table-chart and not a tablebox which don't support such restrictions.

- Marcus

johnw
Champion III
Champion III

I don't think there's a simple way to ignore a list box for an entire table, just for the expressions within the table, each of which need to be individually told to ignore the selections in that list box as specified above. If you do it for every expression, you've done it for the entire table.

krishnacbe
Partner - Specialist III
Partner - Specialist III

Try with alternate state.