Need Help on case statement

[chinnu123]

Hi Team,

Can any one convert below code to qlikview

case when Key<10 then 1

when Key<50 then 2

when Key<500 then 3

when Key< 3000 then 4

when Key< 8678 then 5

when PARTY_RISK_SCORE_RV<10000 then 6

when PARTY_RISK_SCORE_RV>=10000 then 7

end level

Thanks,

Chinnu.

[Sergey_Shuklin · Accepted solution]

Hello!

If(Key<10, 1,

If(Key<50, 2,

If(Key<500, 3,

If(Key<3000, 4,

If(Key<8678, 5,

If(PARTY_RISK_SCORE_RV<10000, 6,

If(PARTY_RISK_SCORE_RV>=10000, 7

))))))) as level