Set analysis issue

[Anonymous]

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

[annafuksa1]

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

[Anonymous]

Thanks you very much Anna.