topic Re: multiple if logic error in QlikView

multiple if logic error

Anonymous — Tue, 25 Sep 2018 19:49:19 GMT

Hello guys and girls,

I have been trying to solved this, but I guess I'm tired, because the logic is escaping my mind.

(

qtde > 15,

RGB(0,0,128),//NAVY

(

qtde <= 15 and qtde >=5,

RGB(0,0,255),//BLUE

(

qtde >=4 AND qtde <=1,

RGB(30,144,255),//DODGEBLUE

RGB(173,216,230)//LightBlue

)

I can't make the DodgeBlue work...any ideas? Thanks

lanlizgu — Wed, 26 Sep 2018 15:29:20 GMT

qtde can't be at the same higher than 4 and less than 1, as there is no any figure with this condition

Could you please share an example of each number?

As far as I understand your development, I understand that you should use an or, not and and for your example.

olivierrobin — Wed, 26 Sep 2018 15:42:07 GMT

try

if(qtcde>15, RGB(0,0,128),//NAVY

,if(qtcde>=5,RGB(0,0,255),//BLUE

,if(qtcde>=1,RGB(30,144,255),//DODGEBLUE

RGB(173,216,230) // lightBlue

)

RGB(173,216,230)//LightBlue

Anonymous — Wed, 26 Sep 2018 16:16:31 GMT

I made a huge logic mistake...I solved it, but couldn't find my post to delete it. You are absolutely right Lan Liz. So the correct is:

(

qtde > 15,

RGB(0,0,128),//NAVY

(

qtde <= 15 and qtde >=5,

RGB(0,0,255),//BLUE

(

qtde <=4 AND qtde >=1,

RGB(30,144,255),//DODGEBLUE

RGB(173,216,230)//LightBlue

)