topic Re: Chart Problem in QlikView

Chart Problem

Wed, 16 Oct 2013 06:46:27 GMT

Pls Help me out.....

tresB — Wed, 16 Oct 2013 06:55:41 GMT

Where is the issue?

sujeetsingh — Wed, 16 Oct 2013 06:57:07 GMT

What is the ISSUE

???????

Wed, 16 Oct 2013 06:59:06 GMT

I have attach the application.Please see to it it will tell u what i want

senpradip007 — Wed, 16 Oct 2013 07:15:33 GMT

I have gone through your application and excel. It is very difficult to understand your issue.

Wed, 16 Oct 2013 07:31:55 GMT

Hi,

Can you explain what you expect as output?

Wed, 16 Oct 2013 09:44:05 GMT

Hiii i am attaching another application pls see to it......

MayilVahanan — Wed, 16 Oct 2013 09:50:29 GMT

Try like this

=Sum(DISTINCT Qty)

Total Mode -> Expression Total instead of Sum Total

Anonymous — Wed, 16 Oct 2013 09:50:58 GMT

Sumit

On your Qty Expression set the Total Mode to Expression Total.

Best Regards, Bill

tresB — Wed, 16 Oct 2013 09:52:28 GMT

PFA.

Select 'Expression Total'

ljackson — Wed, 16 Oct 2013 09:53:18 GMT

If I understand correctly, you want to show totals by customer, so the total for customer 1 is 80.

You need to use a pivot table, and in the presentation tab select 'show partial sums' for the expressions required.

I've changed your example and reattached.

Hope this is what you wanted!