topic How to use range in if condition in QlikView

How to use range in if condition

bushpalaamarnat — Mon, 23 Jul 2018 10:50:10 GMT

Hi All,

I am trying to use the following equation to get a color if value if between -5% and 5%.

For some reason, it is not working. could any one advise.

IF( $(vAcc) >= -0.05 <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))

sergio0592 — Mon, 23 Jul 2018 10:59:38 GMT

Hi, try with :

IF( fabs($(vAcc)) <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))

tresB — Mon, 23 Jul 2018 11:00:31 GMT

Try like:

IF( $(vAcc) >= -0.05 AND $(vAcc) <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))

bushpalaamarnat — Mon, 23 Jul 2018 11:13:37 GMT

it did not work, hence i was contacting the community.

bushpalaamarnat — Mon, 23 Jul 2018 11:43:47 GMT

IF( fabs($(vBias)) <= 0.05 , $(vTemplate_GSK_SecondaryColour4_1), $(vTemplate_GSK_SecondaryColour2_1))