Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik Community,
Fairly new to Qlik and the Qlik Community but have heard great things about the support here so I thought I would give it a try. I have been through basic developer training, however I'm running into an issue finding out how to use an If / Or statement in Qlik. I'm trying to evaluate the result of certain columns of a chart using a combination of IF and OR statements. The expected result should populate text if true.
In plain English:
If the field $ Refunds is greater than or equal or $3,000.00, Or # Refunds is greater than or equal to 10, then populate text 'high refunds', if not then populate text 'normal activity'.
Current formula (underlined is where error is occurring).
If ([$ Refunds]>=3000.00,'HIGH $ REFUNDS')
OR ([# Refunds]>=10,'HIGH REFUNDS', 'NORMAL')
I've done this in Excel a thousand times but it doesn't seem the same in Qlik, Any assistance would be appreciated.
Try this:
If([$ Refund] >= 3000 or [# Refund] >= 10, 'High Refund', 'Normal')
Thanks Sunny! I think worked great. I must have been overthinking it.
Great, I am glad it worked
Rest assured, the IF() function in QlikView is extremely similar to its Excel counterpart. The major differences are:
Best,
Peter