rgb function

[yadav_anil782]

Dear All,

i'm trying to plot states in  geo analysis  in same color - green . and i wants to give condition : if   emp count is more then 0 and less the 100 then color should be light green , and if count is more then 100 and less then 200 then color should be dark green and if count is more then 300 then color should be super dard

now im using this script

=if(COUNT(ProjectID) > 0 AND COUNT(ProjectID) < 100, argb(64, 255, 0, 0),

if(COUNT(ProjectID) >= 100 AND COUNT(ProjectID) < 200,argb(128, 255, 0, 0),

if(COUNT(ProjectID) >= 200 AND COUNT(ProjectID) < 300, argb(192, 255, 0, 0),

if(COUNT(ProjectID) >= 300,argb(255, 255, 0, 0) ))))

[Chanty4u]

simplify this

=if(COUNT(ProjectID) > 0 and <100 , argb(64, 255, 0, 0),

if(COUNT(ProjectID) >= 100 AND  < 200,argb(128, 255, 0, 0),

if(COUNT(ProjectID) >= 200 AND  < 300, argb(192, 255, 0, 0),

if(COUNT(ProjectID) >= 300,argb(255, 255, 0, 0) ))))

[saumyashah90]

=if(COUNT(ProjectID) > 0 AND COUNT(ProjectID) < 100, RGB(0,255,0),

if(COUNT(ProjectID) >= 100 AND COUNT(ProjectID) < 200,RGB(0,64,0),

if(COUNT(ProjectID) >= 200 AND COUNT(ProjectID) < 300, RGB(0,64,128),

if(COUNT(ProjectID) >= 300,RGB(64, 0, 0) ))))

[Kushal_Chawda]

Use colormix wizard

Qlikview Heatmaps

[yadav_anil782]

my requirement is only  green , i mean coordinator to count color should be reflect light green to dark gree

[saumyashah90]

=if(COUNT(ProjectID) > 0 AND COUNT(ProjectID) < 100, RGB(0,255,0),

if(COUNT(ProjectID) >= 100 AND COUNT(ProjectID) < 200,RGB(0,170,0),

if(COUNT(ProjectID) >= 200 AND COUNT(ProjectID) < 300, RGB(0,108,0),

if(COUNT(ProjectID) >= 300,RGB(0,64, 0) ))))

[sunny_talwar]

What exactly is the issue you are facing? Is the if statement not working? Is it very slow?

[Anonymous]

Argb function get this vars -> ARGB(Alpha, Red, Green, Blue). Use RGB function RGB(Red, Green, Blue).