Conditional formatting of values Qliksense straight Table

[georgegv]

Hi

I need to format values in Qliksense straight Table. The Values will have to be evaluated based on % achieved

i.e Jan values will be evaluated against 30% so all values lower than 30% red, Feb against 60% and March against 90%

I included an example of the data in the form of a screenshot

[dplr-rn]

2 options

1 do a bunch of if else conditions e.g.

if(Monthx='Jan',if(Sum(Valuesx)<30.0,Red(),Green())

   If(Monthx='Feb',if(Sum(Valuesx)<30.0,Red(),Green()),

 if(.....

)

    )

better option create a dummy table with the monthly reference values

load * inline [
Monthx, RefValuesx
Jan, 30
Feb, 60
March, 90
];
load * inline [
Yearx,Monthx, Valuesx
2018,Jan, 31
2018,Feb, 65.3
2018,March, 90.3
2019,Jan, 29
2019,Feb, 55.3
2019,March, 80.3
];

dimensions - yearx, monthx

measure - if(Sum(Valuesx)<Only(RefValuesx),Red(),Green())

result

[georgegv · Accepted solution]

Thanks. I used option one and it works well.