Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
jmarinesc
Contributor III
Contributor III

SUM Error in Expression

Hi QLIKCommunity:

I need to sum ESvnatural field, if 2 conditions like below;

SUM(IF((ESidproducto=1)and (EStmovimiento=S)),ESvnatural)

But I get Error in expression,, please you help on this...Tk in advanced

James Marines

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

May be you should use like this

SUM(IF((ESidproducto=1)and (EStmovimiento=S),ESvnatural))

You can go with set analysis like

SUM({<ESidproducto={1},EStmovimiento={'S'}>} ESvnatural)

View solution in original post

5 Replies
MayilVahanan

HI

Try like this

=Sum({<ESidproducto={1},EStmovimiento={'S'}>}ESvnatural)

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
CELAMBARASAN
Partner - Champion
Partner - Champion

May be you should use like this

SUM(IF((ESidproducto=1)and (EStmovimiento=S),ESvnatural))

You can go with set analysis like

SUM({<ESidproducto={1},EStmovimiento={'S'}>} ESvnatural)

jmarinesc
Contributor III
Contributor III
Author

Great!   It works , Thanks a lot .....I am very glad for all this strong QlikSupport.....I really appreciate it.

Jaime Marines

jmarinesc
Contributor III
Contributor III
Author

Great!   It works , Thanks a lot .....I am very glad for all this strong QlikSupport.....I really appreciate it.

Jaime Marines

jmarinesc
Contributor III
Contributor III
Author

Great!   It works , Thanks a lot .....I am very glad for all this strong QlikSupport.....I really appreciate it.

Jaime Marines