Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
Hi,
I'm not sure I understand,
but if you want to ignore selection use set analysis with 1< ($ take in account selection)
regards
Your requirement is not clear. Please provide some sample input & output. From what i understand, you can try 'only' code of set analysis.