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: 
Anonymous
Not applicable

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
sunny_talwar

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
Specialist II
Specialist II

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
Specialist
Specialist

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