topic Re: Chart Issue - Strange Behaviour in QlikView

Chart Issue - Strange Behaviour

aveeeeeee7en — Fri, 23 May 2014 09:41:22 GMT

Hi Community

I got stuck at one point while creating Combo Chart.

Kindly see the Attachment.

Regards

Aviral Nag

Re: Chart Issue - Strange Behaviour

tresB — Fri, 23 May 2014 09:51:05 GMT

Re-write the expression as:

=Sum([Normal Sales]-PercentageValue*[Gross Sales])/1000000

Re: Re: Chart Issue - Strange Behaviour

aveeeeeee7en — Fri, 23 May 2014 10:14:02 GMT

Check for this case:

//CHANNEL/Oce Wide Format Printer/OCE TDS400/14-Feb-14

Desired Result Net Sales - 44265

According to your expression - 132795

Re: Chart Issue - Strange Behaviour

marcus_malinow — Fri, 23 May 2014 10:21:36 GMT

You need to think a bit more about what your expression is.

Normal Sales and Gross Sales are actual amounts, whereas PercentageValue is a percentage.

Therefore subtracting PercentageAmount from either of your actual amounts is meaningless.

What is your Net Sales Calculation supposed to be?

Sum(Normal Sales) - Sum(Gross Sales* PercentageValue) ?

Re: Re: Chart Issue - Strange Behaviour

aveeeeeee7en — Fri, 23 May 2014 10:57:55 GMT

So what should I do in this case???

Re: Chart Issue - Strange Behaviour

marcus_malinow — Fri, 23 May 2014 12:57:21 GMT

I asked you a couple of questions earlier, if you can't provide answers then how is anyone supposed to help you?

Why don't you provide an example of values of Normal Sales, Gross Sales, and Percentage Value (non zero please!), and tell us what you think the result of the Net Sales Calculation should be?