topic Re: Sub Total not showing up in QlikView

Sub Total not showing up

gagimittal — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I made a Pivot table in Qlikview and for one of the expressions I am not getting the subtotal. I have selected Partial Sums under Presentation.

I have used following syntax for the expression.

If(([A]-[B])<0,([A]-[B]),0)

For individual rows of data it works fine but doesn't showing the subtotal.

Your response would be much appreciated.

Thanks & Regards

K Mittal

Re: Sub Total not showing up

wandererroch — Fri, 21 Jun 2019 19:19:18 GMT

You'll need an aggregation function to make a total show up. If you wrap your expression in sum() or a similar function you should then get a subtotal

Re: Sub Total not showing up

Brett_Bleess — Mon, 22 Jul 2019 18:25:33 GMT

Potentially, the following link might be of some help, not sure, but worth checking, I believe it elaborates on the other posters comment:

http://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm

Regards,
Brett

Re: Sub Total not showing up

gagimittal — Wed, 31 Jul 2019 13:48:56 GMT

Thanks Brett.

That was helpful.