topic Percentage by Region in QlikView

Percentage by Region

stevejones1 — Thu, 03 May 2018 23:52:09 GMT

Please find the attached doc , i am trying to display the % by Region for each quarter , but unable to figure out expression , i am able to get expression for individual Region but i want to display 1 row for 1 region, currently my region values are duplicating.

Thanks!

Re: Percentage by Region

sunny_talwar — Fri, 04 May 2018 03:02:38 GMT

Try these two expression

Alt($(eAdjExtCostAsiaPQ2), $(eAdjExtCostAsiaPQ1))

Alt($(eAdjExtCostEMEAPQ1), $(eAdjExtCostEMEAPQ2))

Re: Percentage by Region

duncanblaine — Fri, 04 May 2018 03:27:09 GMT

Hi Steve

Looks like Sunny just got in there before me

From what I can see, it looks like the denominator in your Percentages is missing something.

In a simplified example:

Sum({<[SalesOutZyme.Type]={'SPR'}>}SalesOutZyme.AdjExtCost) / Sum(TOTAL <Geo.Region> {<[SalesOutZyme.Type]={'SPR'}>}SalesOutZyme.AdjExtCost)

The TOTAL qualifier will allow the percentage to aggregate across all values in the specified dimension.

I've attached the QVW which includes a new Pivot table which contains the new expressions. You might need to amend to swap in the variables.