topic SQL iif Logic in Qlikview in QlikView

SQL iif Logic in Qlikview

Wed, 01 Jun 2011 14:25:40 GMT

I want to perform the task that if done in SQL would be

Sum(IIF([Field1] = 0,[Field2],0)).

I am having a hard time figuring out how to do it in Qlikview. I have tried

Sum({$<[Field1] = {0} >} [Field2]) . This returned 0.

Any help would be appreciated.

vincent_ardiet — Wed, 01 Jun 2011 14:42:42 GMT

Hi,

Have you try: =sum(if([Field1]=0,[Field2])) ?

Regards,

Vincent

Wed, 01 Jun 2011 14:51:38 GMT

Thanks so much. It worked. Who knew I should try the simplest answer first, I will be sure to do that in the future.