topic Re: 'Show partial sums' when using conditionals in QlikView

'Show partial sums' when using conditionals

Wed, 09 Mar 2016 10:38:59 GMT

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

Re: 'Show partial sums' when using conditionals

MayilVahanan — Wed, 09 Mar 2016 10:43:50 GMT

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

Re: 'Show partial sums' when using conditionals

Anonymous — Wed, 09 Mar 2016 10:44:53 GMT

Sample?

Re: 'Show partial sums' when using conditionals

Digvijay_Singh — Wed, 09 Mar 2016 10:57:54 GMT

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.

Re: 'Show partial sums' when using conditionals

Wed, 09 Mar 2016 10:58:59 GMT

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

Re: 'Show partial sums' when using conditionals

Wed, 09 Mar 2016 11:03:38 GMT

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