topic Looking for calculated dimension expression in QlikView

Looking for calculated dimension expression

vikasshana — Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Looking for calculated dimension expression

Anonymous — Thu, 30 Nov 2017 18:09:54 GMT

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

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

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

Re: Looking for calculated dimension expression

vvira1316 — Thu, 30 Nov 2017 18:11:07 GMT

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.

Re: Looking for calculated dimension expression

Anonymous — Thu, 30 Nov 2017 18:14:19 GMT

will fail for Risc_Scores < 0