SUM Error in Expression

[jmarinesc]

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

[MayilVahanan]

HI

Try like this

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

Hope it helps

[CELAMBARASAN · Accepted solution]

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]

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

Jaime Marines

[jmarinesc]

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

Jaime Marines

[jmarinesc]

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

Jaime Marines