Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks. I used option one and it works well.