Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Sub Total not showing up

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

3 Replies
Contributor III
Contributor III

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

Digital Support
Digital Support

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Contributor
Contributor

Thanks Brett.

That was helpful.