Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

vikasshana
New Contributor III

Looking for calculated dimension expression

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

3 Replies
roharoha
Valued Contributor III

Re: Looking for calculated dimension expression

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

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

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

vvira1316
Valued Contributor II

Re: Looking for calculated dimension expression

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.

roharoha
Valued Contributor III

Re: Looking for calculated dimension expression

will fail for Risc_Scores < 0