Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to use set analysis to work out sales as a % of total sales for a selection (region) compared to total sales (country) within a selected year by age group.
With age group as my dimension, I have used the following expresion to calculate sales for the selection -
SUM(sales)/SUM(TOTAL(sales))
I have been trying to use set analysis to compare this with sales as a % of total sales for the country. I have used the following expression -
SUM({1}sales)/SUM({1}TOTAL sales)
Unfortnunately, the country % isnt showing the correct value. I think it might be excluding the selction 'Year' and working out sales as a % of total sales for all years.
I would be grateful for any advice.
Thanks
Greg
yes, you can do the same it gonna look
Sum( {$<region = , college= >} Sales)
expresion 'field =' make that Qlikview will ignore current selection
or if you have for example Collage: A and B
you can use expression
Sum( {$<region = , college= {'A', 'B'}>} Sales)
it gonna work the same just first version is just easier , Second is good when you want to choose only one collage
Thanks you very much Anna.