Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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