Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

mariovella
New Contributor

Sum % of a variable

Can anyone kindly help me?

I have two dimensions (Region, city) and a measure (sale). Here the values

 

RegionCitySales
LombardyMilan127.391,33
LombardyMilan119.348,40
LazioRoma   18.511,46
TuscanyFlorence   87.786,00
TuscanySiena   55.312,22
TuscanyFlorence200.691,51
LombardyPavia   68.262,00

How can I manage the set analysis in order to have the sales in Milan as a percentage of the sales in Lombardy ?

The result is (127.391,33+119.348,40)/(127.391,33+119.348,40+68.262,00).... but I don't know what to do in  a set analysis.

Thanks for any help

Mario

1 Reply

Re: Sum % of a variable

Community Browser