topic Re: IF FUNCTION in QlikView

IF FUNCTION

Anonymous — Wed, 31 Jul 2013 11:50:49 GMT

Hi!

This expression returns SALES for only D instances, and i would want both C and D.

= SUM(IF(LEFT([FIELDNAME],1) = 'C','D', (SALES)))

Thanks

er_mohit — Wed, 31 Jul 2013 12:10:20 GMT

try this

= SUM(IF(LEFT([FIELDNAME],1) = 'C' or LEFT([FIELDNAME],1)='D', (SALES)))

= SUM(IF(LEFT(wildmatch([FIELDNAME],'C','D'),1) , SALES))

Anonymous — Wed, 31 Jul 2013 12:53:58 GMT

We can simplify it a little:

SUM(IF(wildmatch([FIELDNAME],'C*','D*'), SALES))

VishalWaghole — Thu, 01 Aug 2013 07:36:17 GMT

Try this

SUM(IF(match(LEFT([FIELDNAME],1),'C','D'), SALES))

SUM(IF(wildmatch([FIELDNAME],'C*','D*'), SALES))

Thanks