topic Re: if condition in QlikView

if condition

krish2459 — Sat, 16 Nov 2024 00:07:52 GMT

Hi,

Please help me with the below if condition.

It's not working.

If( RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating])<1.5,rgb(0,204,102),

If( RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating])>=1.5
and RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating])<2.5,rgb255,215,0),

If( RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating])>=3.5
and RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating])<4.5,rgb(255,99,71),

If( RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating])>=4.5,rgb(255,0,0))))

Thanks..

Re: if condition

Saravanan_Desingh — Mon, 17 Aug 2020 22:40:48 GMT

In a quick look..

If( RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating])<1.5,rgb(0,204,102),

If( RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating])>=4.5,rgb(255,0,0))))

Re: if condition

Kushal_Chawda — Mon, 17 Aug 2020 23:09:00 GMT

I found two syntax errors

If( RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating])<1.5,rgb(0,204,102),

If( RangeAvg([Location Activities],[Primary Business Use],[Maximum Potential Loss],[Employee Occupancy],[ISOS Rating])>=4.5,rgb(255,0,0)))))

Re: if condition

krish2459 — Tue, 18 Aug 2020 05:02:15 GMT

Thanks for the finding.

But the above syntax I'm just able to only fill two colors.

Thanks..

Re: if condition

Brett_Bleess — Tue, 01 Sep 2020 15:40:59 GMT

@Kushal_Chawda I know you were having some issues with notifications, so will see if this kicks things back to you for another look, as I do not think I am going to be of much help on this one! 🙂