Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Not applicable

Brian,

This is a great extension and I have lots of uses for it.

I have a question though, I want to use four colors versus three.  I have built the following formula to determine the colors but I cannot determine where I need to put this formula.

If(Num >0 and Num <25, '#F2EF1B', If (Num >24 and Num <50, '#E57A00', If (Num>49 and Num <75, '#00E507', If (Num

>74, '#439400', '#00E507'))))

Can you help?

Thanks,

Mike Coleman