topic Re: SUM IF in QlikView

SUM IF

realpixel — Mon, 18 Nov 2013 17:24:08 GMT

Hello,

I have the following expression

=sum(if((IDEFAC='L'),MFAC))

It's works fine, now I want to add for value IDEFAC 'L' and 'N' and 'S' and 'F'

I try this expression

=sum(if((IDEFAC='L' and IDEFAC='N' and IDEFAC='S' and IDEFAC='F'),MFAC)) but it's not works

Someone have an idea?

Clever_Anjos — Mon, 18 Nov 2013 17:26:12 GMT

Maybe using Set Analysis makes things easier

=sum({<IDEFAC={'L','N','S','F'>}MFAC))

Clever_Anjos — Mon, 18 Nov 2013 17:26:41 GMT

But if you insist using IF

=sum(if((IDEFAC='L' OR IDEFAC='N' OR IDEFAC='S' OR IDEFAC='F'),MFAC))

MK_QSL — Mon, 18 Nov 2013 17:30:24 GMT

SUM({<Customer_Name = {'A','B','C','D'}>}QTY)

MayilVahanan — Mon, 18 Nov 2013 17:31:55 GMT

Try like this

=sum({<IDEFAC={'L','N','S','F'>} MFAC) // or function

=sum({<IDEFAC={'L'}> * <IDEFAC={'N'}> * <IDEFAC={'S'}> * <IDEFAC={'F'}>} MFAC) // And Function

realpixel — Mon, 18 Nov 2013 17:40:27 GMT

Thank you Clever,

Expression under works fine

=sum(if((IDEFAC='L' OR IDEFAC='N' OR IDEFAC='S' OR IDEFAC='F'),MFAC))

MK_QSL — Tue, 19 Nov 2013 10:37:43 GMT

FYI .... IF is much slower compare to SET ANALYSIS.