Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

diwakarnahata
Contributor

TOTAL with relative volume

Hi All,

I have a cyclic group of Country,State,Category etc. and i have a Volume metric, and a Volume Share metric (which is the Volume made relative)  shown. This is shown in a scatter chart, Volume Vs Share.

Now,consider that i have Countries shown in the Cyclic group, and when i select a few points (Countries) from the scatter chart, the share is not calculated based on all the Countries, but is recalculated based on the selected countries. So, if 2 points are selected, then the share would come out to be say 40% and 60% which is the relative share of the two countries, and not amongst the whole.

The expected behaviour is to show a zoom in functionality, and the actual % should not change with Selection of Countries, but should vary with other selections.

I tried using expressions like =sum(Volume)/sum(TOTAL Volume) but even that behaves the same way, and the denominator is affected by the selection of Countries in the Scatter Plot.


Let me know how this can be achieved in QlikView.


Thanks,

Diwakar

1 Solution

Accepted Solutions
Not applicable

Re: TOTAL with relative volume

or sum( Volume)  / sum({<Country=>} TOTAL Volume)

:-)

2 Replies
Not applicable

Re: TOTAL with relative volume

Use a set expression like

sum({<Country=,State=,Category=>} Volume)  / sum({<Country=,State=,Category=>} TOTAL Volume)

or

sum({<Country=>} Volume)  / sum({<Country=>} TOTAL Volume)

Not applicable

Re: TOTAL with relative volume

or sum( Volume)  / sum({<Country=>} TOTAL Volume)

:-)

Community Browser