Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

hwinkelhorst
New Contributor

Table Column insensitive to dimension selections

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.

3 Replies
MVP
MVP

Re: Table Column insensitive to dimension selections

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?

ogautier62
Valued Contributor II

Re: Table Column insensitive to dimension selections

Hi,

I'm not sure I understand,

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

regards

isingh30
Contributor III

Re: Table Column insensitive to dimension selections

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