topic Re: % CALCULATION in QlikView

% CALCULATION

Thu, 04 Dec 2014 11:40:55 GMT

I want to calculate the % so that 129 should be divide by 154 & 17/154 same for the others.

Each value should be divide by total of it value

its_anandrjs — Thu, 04 Dec 2014 11:50:31 GMT

Hi,

Did you try TOTAL key word

Ex:-

Sum( Metrics ) / Sum( TOTAL Metrics )

Regards

Anand

anbu1984 — Thu, 04 Dec 2014 11:50:37 GMT

If your expression for K is Sum(Sales), then to calculate percentage use Sum(Sales) / Sum(Total Sales)

Anonymous — Thu, 04 Dec 2014 12:03:28 GMT

Hi Shwetha,

In expression tab of chart properties add:

=sum(sales)/sum(Total Sales)

In Number tab:

Tick the checkbox show in percent option.

you will have % calculation and display percent in the chart

Regards

Neetha

Thu, 04 Dec 2014 12:10:02 GMT

Hi,

Sum(K)/Sum( Total <Dimension1><Dimension2> K).

Hope this will help

Regards,

Joshmi

Thu, 04 Dec 2014 12:24:07 GMT

Hi.

It works only with <Dimension2>.

Sum(K)/Sum(Total <Dimension2> K)

is right expression.

Fri, 13 Nov 2015 07:55:03 GMT

Thats right Formula