topic Pivot Chart Problem in QlikView

Pivot Chart Problem

rohitians — Wed, 29 May 2013 04:23:29 GMT

Hello,

I have a pivot chart where i have selected show subtotal,

But for few expressions it does not shows subtotals,

what is the problem...has any one cmome across this..

Thanks and Regards,

Rohit Yadav

Re: Pivot Chart Problem

sushil353 — Wed, 29 May 2013 05:05:32 GMT

hi,

Please provide some relavent information to get the answere.

Please go through this.

http://community.qlik.com/docs/DOC-2380

~Sushil

Re: Pivot Chart Problem

Wed, 29 May 2013 05:22:32 GMT

in yor expression must be use sum() function then that is sum(expression) then check show partial sum which is in presentation tab. also try to select on the basis og first and second dimension

example-- sum(sales)

presentation tab--> select dimension then check show partial sum

Re: Pivot Chart Problem

er_mohit — Wed, 29 May 2013 05:34:09 GMT

See the attached image

Re: Pivot Chart Problem

rohitians — Wed, 29 May 2013 07:41:40 GMT

Hey Guy's thanks for your reply,

I did sum(aggr(expression)) and now it is showing the sub total.

Thanks and Regards,

Rohit