Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

'Show partial sums' when using conditionals

Hi,

I have a pivot table which has Properties-->General-->'Calculation Condition' and also Properties-->Dimensions-->'Enable conditional' and also Properties-->Expressions-->Conditional.

The problem is that I need totats for the expressions shows but when I try to use Properties-->Presentation-->'Dimensions and Expressions'-->'Show Partial Sums'(check box) this check box is not available for any dimension and expression.

Is there other place in properties or alternative solution to get totals in this 'complex' pivot table??

Thanks

5 Replies
MayilVahanan

HI

Please post a sample file, so that, we can able to find the solution,.

Thanks & Regards,
Mayil Vahanan R
balrajahlawat
Champion
Champion

Sample?

Digvijay_Singh
Master III
Master III

Partial sum is available for Dimensions only in pivot tables, which means it will subtotal the expressions for the checked Dimension level. I don't think adding conditions should make the difference in that. See the sample attached and see if you can recreate the problem.

Capture.JPG

Not applicable
Author

See the attached,

the pivot table is 'Balance' , by the way I wonder why I am not able to see the dimension DescEpig2 enterely.

Thanks

Not applicable
Author

Maybe the problem is other anyway I am looking for the total column.