Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aveeeeeee7en
Specialist III
Specialist III

Chart Issue - Strange Behaviour

Hi Community

I got stuck at one point while creating Combo Chart.

Kindly see the Attachment.

Regards

Aviral Nag

5 Replies
tresesco
MVP
MVP

Re-write the expression as:

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

aveeeeeee7en
Specialist III
Specialist III
Author

Check for this case:

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

Desired Result Net Sales  - 44265

According to your expression - 132795

marcus_malinow
Partner - Specialist III
Partner - Specialist III

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) ?

aveeeeeee7en
Specialist III
Specialist III
Author

So what should I do in this case???

marcus_malinow
Partner - Specialist III
Partner - Specialist III

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?