Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Not applicable

Pivot subtotal

Hi,

In Pivot table how to get the row based sub totals.

2 Replies
Partner
Partner

Pivot subtotal

Hi,

Just add another Expression Which has the expression as Column(1)+Column(2).... .This will give you the Sum of that Row.

Not applicable

Pivot subtotal

Thanks Syed,

In the pivot table you have the option of converting the dimension(Rows ) in to columns. Also we have options to display the subtotals at the top or bottom of the chart. I was looking for the similar option. if the user is trying to change the rows in to columns at runtime he may looking for the totals to be displayed at the each row level .Instead of creating the expression.