topic Re: qlik sense - setting the totals in Pivot Table rows in App Development

qlik sense - setting the totals in Pivot Table rows

Mon, 17 Apr 2017 17:27:46 GMT

In QlikView, I know how to set the formula for the totals row in a pivot table as the expression, or sum of rows, etc.

In QlikSense, it defaults to "total", which I assume is the total for the expression. However, in my case, I want it to be sum of rows.

When I click on the "Presentation" icon, I get this:

However, when I click on the slider, I get this:

The "Position" drop down doesn't drop down, and I can only change the label, not the data.

My rows are Qty, Cost, Extended Cost

my formula are sum(ItemQty), sum(ItemCost), and sum(ItemQty)*Sum(ItemCost). They are fine, except in the

total fields, where the displayed total is clearly incorrect:

Clearly, the "Extended Cost" is not equal to the sum of Qty (13563) x the sum of all ItemCosts ($498k).

I want the sum of rows for the Ext Cost to appear. Is this possible?

shraddha_g — Tue, 18 Apr 2017 10:44:55 GMT

Is this issue with Pivot table of Straight table.

In Straight Table in Every measure you will get a option as Total Function.. From that drop down select Sum as Function..

In Pivot table YOu will have to write Seperate expression for Total

eg.

if(rowno(),

sum(Aggr(Sum(Qty), Dimension)),

Sum(Qty)

)

praichubb — Wed, 13 May 2020 17:56:10 GMT

Thank you for being precise and providing the details on where the follow set expression can be used. This was very helpful to me :). Thanks again!.

Or — Wed, 13 May 2020 18:41:49 GMT

Looks like you've already gotten a working response, but I'm curious: why not write the expression as Sum(QTY*ItemCost) in the first place?

As for the more complex option, another alternative should be:

Sum(Aggr(Sum(QTY)*Sum(ItemCost),Dimensions))