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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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