Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jmarinesc
New 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

Re: SUM Error in Expression

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)

5 Replies

Re: SUM Error in Expression

HI

Try like this

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

Hope it helps

Re: SUM Error in Expression

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
New Contributor III

Re: SUM Error in Expression

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

Jaime Marines

jmarinesc
New Contributor III

Re: SUM Error in Expression

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

Jaime Marines

jmarinesc
New Contributor III

Re: SUM Error in Expression

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

Jaime Marines

Community Browser