topic Re: rgb function in QlikView

rgb function

yadav_anil782 — Thu, 05 May 2016 06:35:50 GMT

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) ))))

Re: rgb function

Chanty4u — Thu, 05 May 2016 06:38:08 GMT

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) ))))

Re: rgb function

saumyashah90 — Thu, 05 May 2016 06:45:56 GMT

=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) ))))

Re: rgb function

Kushal_Chawda — Thu, 05 May 2016 06:50:38 GMT

Use colormix wizard

Qlikview Heatmaps

Re: rgb function

yadav_anil782 — Thu, 05 May 2016 06:53:38 GMT

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

Re: rgb function

saumyashah90 — Thu, 05 May 2016 07:16:24 GMT

=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) ))))

Re: rgb function

sunny_talwar — Thu, 05 May 2016 08:31:19 GMT

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

Re: rgb function

Anonymous — Thu, 05 May 2016 13:25:01 GMT

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