Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
kushalthakral
Contributor 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
MVP & Luminary
MVP & Luminary

Re: Ignore one list box while showing data in a table

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

sum({< YourListboxField = >} Value)

- Marcus

kushalthakral
Contributor III

Re: Ignore one list box while showing data in a table

Hi

I want to apply this to the entire table

Regards

Kushal Thakral

MVP & Luminary
MVP & Luminary

Re: Ignore one list box while showing data in a table

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

MVP
MVP

Re: Ignore one list box while showing data in a table

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.

Partner
Partner

Re: Ignore one list box while showing data in a table

Try with alternate state.