Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
lucasdavis500
Contributor II

Showing Row Total in chart (pivot or straight)

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.

chart.png

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...

2 Replies

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

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

lucasdavis500
Contributor II

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

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.