topic Re: Showing Row Total in chart (pivot or straight) in QlikView

Showing Row Total in chart (pivot or straight)

lucasdavis500 — Wed, 02 Nov 2016 15:57:19 GMT

Im trying to show row totals in my charts, either pivot or straight, it doesn't really matter.

here's a view of my chart.

I can get the column totals by selecting "Show Partial Sums" in my pivot table, or have "Expression Total" Picked in a Straight Table. "Expression Total" shows the same values as "Sum (expression)" under "Total Mode" for me in "Expression" Tab. I can't figure out how to get Row Totals, only column totals. My columns are my Expressions, and the Rows are just one dimension, which each row being the 1 of 5 allowed values...

Re: Showing Row Total in chart (pivot or straight)

sunny_talwar — Wed, 02 Nov 2016 16:00:11 GMT

May be use IsLand table or ValueList() function to create a synthetic dimension and use that to create a chart

Re: Showing Row Total in chart (pivot or straight)

lucasdavis500 — Wed, 02 Nov 2016 16:09:04 GMT

I solved this issue. All of my expressions are stored in variables, so I created a new expression summing my variables.

I.E.

Row Totals = $(vVar1) + $(vVar2) + ..... $(vVarN)

This worked.