topic Re: Table Column insensitive to dimension selections in App Development

Table Column insensitive to dimension selections

Anonymous — Fri, 08 Jun 2018 10:30:30 GMT

Is is possible to have a column in a Qlik Sense ignore the selections in a particular dimension (preferably multiple).

For a product analysis we would like to be able to have one column always show the Total sales in certain product line and the next column show the subtotal of a certain group of selected products within that particular product line.

For example for Customer I would select within the product line Coffee all groups of a certain supplier.

The table would have to show for Customer A the total sales in product line Coffee and in the next column only the sales of the groups of my selection.

Re: Table Column insensitive to dimension selections

sunny_talwar — Fri, 08 Jun 2018 16:32:11 GMT

From what I understand, it should be possible using set analysis... but I am not sure I completely understand what you want. Would you be able to share some sample data and explain what you desire to get as an output?

Re: Table Column insensitive to dimension selections

ogautier62 — Sat, 09 Jun 2018 05:58:51 GMT

Hi,

I'm not sure I understand,

but if you want to ignore selection use set analysis with 1< ($ take in account selection)

regards

Re: Table Column insensitive to dimension selections

isingh30 — Sat, 09 Jun 2018 16:09:03 GMT

Your requirement is not clear. Please provide some sample input & output. From what i understand, you can try 'only' code of set analysis.