Discussion Board for collaboration related to Creating Analytics for QlikView.
How do you keep the colours of a chart dynamic.
I want good to always be green average amber and bad red.
Go to Solution.
Try this instead
check the back ground color of the expression
add pick(match(Status,'Good','Average','Bad'),1,2,3) in the sort tab
In a case like the attached model when there is no data for the one month 201704 for average then it is not dynamic...
presentation -> uncheck supress zero values
Thank you that works Perfect!!!