Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Have you try: =sum(if([Field1]=0,[Field2])) ?
Regards,
Vincent
Thanks so much. It worked. Who knew I should try the simplest answer first, I will be sure to do that in the future.