Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2013-04-08 04:36 AM

How to use Sum with If

Hi!

I am new at QV!

When I try to do an chart with following expression I get wrong figure. Could somebody help me, what I done wrong?

sum(Sales)                                                  = 100 Correct

sum(if(BuyingFunction = '1',Sales))             = 120 Not correct, should be 80, because we have other BuyingFunction. How can it be mor than 100?

Labels (1)
Labels
437 Views
0 Likes
0 Replies