Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
gagimittal
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
wandererroch
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

Brett_Bleess
Support (Former)
Support (Former)

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

Thanks Brett.

That was helpful.