topic Re: Pivot table % in QlikView

Pivot table %

Fri, 07 Feb 2014 12:25:16 GMT

Hi all,

I got a pivot table containing the following information:

Divsion Name weeks: Revenue 2014 Planned 2014 Revenue Cumulative 14 Planned Cum 14

- 1

.....

Now i want to divide the Revenue cum 2014 / Budget cumulative to get a % that shows me how much of the planned Revenue has been achieved. However i can't seem to get the right expression(definition) that will show me this %.

Any got a clue what I am doing wrong?

Re: Pivot table %

Gysbert_Wassenaar — Fri, 07 Feb 2014 13:37:51 GMT

Try use column references. Either use the labels [Revenue Cumulative 14]/[Planned Cum 14] or column numbers column(3)/column(4)

Re: Pivot table %

Fri, 07 Feb 2014 13:56:05 GMT

Thanks for the quick response Gysbert.

Using the column function gives me the right results however if I would add another column inbetween the 3d and 4d column I need to change the columns to 4 and 5 and 5.

Re: Pivot table %

Gysbert_Wassenaar — Fri, 07 Feb 2014 13:58:01 GMT

That's why it's also possible to use expression labels.

Re: Pivot table %

Fri, 07 Feb 2014 14:00:35 GMT

Yes, using those is the best option. Thank you very much!