Looking for calculated dimension expression

[vikasshana]

Hi,

I've a column like below in my Qlikview.

RISK_SCORE
0
1
2
3
4
5
6
7
8

I'm looking for a calculate dimension expression in pivot table when Risk_Score>0 and Risk_Score<=3 it needs to be 'LOW', if Risk_Score>3 and Risk_Score<=6 it needs to be 'MEDIUM' and when Risk_Score>6 needs to be 'HIGH'.

Regards,

Vikas

Message was edited by: Bharath Vikas Shanagonda

[Anonymous]

if ("Risk_Score">0 and "Risk_Score"<=3,'LOW',

if("Risk_Score">3 and "Risk_Score"<=6,'MEDIUM',

     if("Risk_Score">6 ,'HIGH')))

[vvira1316]

Hi,

Have you tried following

=If(Risk_Score>0 and Risk_Score<=3,  'LOW',

If(Risk_Score>3 and Risk_Score<=6, 'MEDIUM', 'HIGH'))

What value it should be for 0 Risk_Score? You may change expression accordingly.

[Anonymous]

will fail for Risc_Scores < 0