topic Re: chart--> pivot table cumulative in QlikView

chart--> pivot table cumulative

rdsuperlike — Mon, 11 May 2015 04:38:41 GMT

I am able to apply full accumulation on expressions for line chart but I am not able to do same for pivot table.

It shows disabled for pivot table.

Can someone help me here?

Re: chart--> pivot table cumulative

amit_saini — Mon, 11 May 2015 04:49:39 GMT

Hi,

Yes pivot table is not having that feature , so you can't see .On the other hand as you mentioned its one of the feature of Line chart.

Thanks,

Re: chart--> pivot table cumulative

Mon, 11 May 2015 04:53:36 GMT

Don't think this option is there for pivot. You need to aggregate using expression

Re: chart--> pivot table cumulative

rdsuperlike — Mon, 11 May 2015 05:42:11 GMT

can you give an example as to how to aggregate in expression?

Re: chart--> pivot table cumulative

jonathandienst — Mon, 11 May 2015 05:52:55 GMT

You will need to have an expression something like this:

RangeSum(Above(<your expression>, 0, RowNo())

For more detailed help, post a sample qvw with representative data and the pivot table in which you want to perform the accumulation.

Re: chart--> pivot table cumulative

amit_saini — Mon, 11 May 2015 05:56:25 GMT

Hi,

See the attachment.

Thanks,

Re: chart--> pivot table cumulative

rdsuperlike — Mon, 11 May 2015 17:12:34 GMT

Thanks.

But when i convert it into pivot table it results into 0.

I just changed ur test straight table to pivot table and then chnaged months as the columns and vaues as row. But as soon as I do that it shows 0.

Re: chart--> pivot table cumulative

Anonymous — Mon, 11 May 2015 17:28:43 GMT

Works for me, see attached

Re: chart--> pivot table cumulative

rdsuperlike — Mon, 11 May 2015 17:40:09 GMT

Ok. Just remove the sales from the dimension.

Then get the months as columns.

You will see getting populated as 0.

I am not able to attach the qvw here.

so i create a new thread. plz chk my file here

Pivot table---cummulative--rangesum

Re: chart--> pivot table cumulative

Anonymous — Mon, 11 May 2015 17:49:50 GMT

Well, what the purpose of the pivot table in this case? Use straight table, horizontal.

Re: chart--> pivot table cumulative

Anonymous — Mon, 11 May 2015 18:01:26 GMT

Looked at the other discussion.

Yes, sunindia got it right, the functions above() and rowno() are not useful here, just take a look at "help". Still, if you have only one dimension, there is no reason to use pivot table.

Re: chart--> pivot table cumulative

santhoo_san — Mon, 11 May 2015 18:11:25 GMT

See if this helps

Re: chart--> pivot table cumulative

sunny_talwar — Mon, 11 May 2015 18:58:05 GMT

I agree with you Michael Solomovich‌. Straight table def. makes more sense and thanks for introducing the horizontal straight table. I did not know that you can transpose a straight table.

Best,

Sunny