This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration on QlikView Management.
I've a column like below in my Qlikview.
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'.
Message was edited by: Bharath Vikas Shanagonda
if ("Risk_Score">0 and "Risk_Score"<=3,'LOW',
if("Risk_Score">3 and "Risk_Score"<=6,'MEDIUM',
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.
will fail for Risc_Scores < 0