topic Pivot table one expression horizontal in QlikView

Pivot table one expression horizontal

ester_pr — Thu, 01 Dec 2011 13:33:11 GMT

Hi,

I have to present in pivot table sum by currency, when i have dimansions vertical and the currency is horizontal, in edision I have to put a column at the end that sums all by the local currency

for that I have made a calculation in the script but how do i put that sum as one column at the end of that pivot table???

Tanks,

Ester

Pivot table one expression horizontal

matt_crowther — Thu, 01 Dec 2011 16:56:22 GMT

It looks as thoug you need to look into using the 'Show Partial Sums' checkbox on the Presention tab of the chart properties dialog - select the relevant dimension you need and check the box - a total column will be added to the end of that dimension.

Hope that helps,

Matt - Visual Analytics Ltd

Pivot table one expression horizontal

Anonymous — Fri, 02 Dec 2011 02:22:40 GMT

Try adding an additional Expression to your Table with you calculation in it; ensure that the new expression is the very last on in your Expressions list. You should see the new column added to the end of your table.

Pivot table one expression horizontal

ester_pr — Sun, 04 Dec 2011 06:00:54 GMT

The problem is that it makes column to every currency separately and i need it to one column to all

Pivot table one expression horizontal

ester_pr — Sun, 04 Dec 2011 06:05:53 GMT

Matt, the calculation is in the script because every currency have a different rate so Partial Sums does not work for me