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

Ignore one list box while showing data in a table

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

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

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

marcus_sommer — Thu, 23 Jun 2016 15:02:10 GMT

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

sum({< YourListboxField = >} Value)

- Marcus

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

kushalthakral — Thu, 23 Jun 2016 15:12:21 GMT

I want to apply this to the entire table

Regards

Kushal Thakral

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

marcus_sommer — Thu, 23 Jun 2016 17:42:16 GMT

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

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

johnw — Thu, 23 Jun 2016 17:50:38 GMT

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.

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

krishnacbe — Thu, 23 Jun 2016 17:59:47 GMT

Try with alternate state.