topic Re: Rangesum in QlikView

Rangesum

brijesh1991 — Fri, 17 May 2013 07:53:38 GMT

Hi All,

As shown in attachment, what I want is something like this:

I have a pivot table, inside that there are two dimentions: 1. Month(Apr, May, June) 2. Mxyz(M1,M2,M3....). and I have an expression for count(fieldname).

Now look at the image that I have provided.

I have calculated running sum using rangesum function. Now I wanted to calculate percentage(running sum/ total)

Look at Row 7 for example: 3.42/6395.61=0.05%, 12.94/6395.61=0.20%

please suggest. . .

Re: Rangesum

Fri, 17 May 2013 08:02:29 GMT

try this expression

(sum(fieldname)/sum(total fieldname))*100

example-

sum(fieldname) = 3.42

sum(total fieldname) = 6395.61

Then output =0.05%

Re: Rangesum

brijesh1991 — Fri, 17 May 2013 08:45:48 GMT

Thanks vishwaranjan for your efforts. . .

But I have to do running sum of 15 columns. i.e rangesum(Before(sum(fieldname),0,15)), then this rangesum/total of this all rangesum. . .

We can do it using individual 15 different expressions, but that's stupidity. . .wanted more dynamic expression. . .

please suggest. . .