topic Re: Sum as a % of dimension in QlikView

Sum as a % of dimension

mariovella — Sun, 13 May 2018 14:16:36 GMT

Can anyone kindly help me?

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

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

sunny_talwar — Mon, 14 May 2018 15:07:21 GMT

May be this

Sum(Sales)/Sum(TOTAL <Region> Sales)

campbellr — Tue, 15 May 2018 02:59:09 GMT

Hi Mario

The set analysis to get sales for milan as a percentage of sales lombardy:

Sum({<City={'Milan'}>} Sales) / Sum({<Region={'Lombardy'}>} Sales)

Ron

if you want it to be based on selection then it can get a little trickier

mariovella — Tue, 15 May 2018 12:10:20 GMT

Ron,

thanks a lot for your help.

As you said, I'm actually looking for a formula based on selection.

Can you help me ?

THANKS

sunny_talwar — Tue, 15 May 2018 12:12:13 GMT

I'm actually looking for a formula based on selection.

Can you elaborate a little on this?

mariovella — Tue, 15 May 2018 12:25:45 GMT

Great!! Thanks a lot Sunny. A great help for me

campbellr — Wed, 16 May 2018 01:22:58 GMT

you can try this, similar to what Sunny suggested.

Sum(total <city> Sales) / Sum(total <Region> Sales)