I am making a straight table chart in Qlikview and I am trying to select certain values in the chart by using a button.
My chart looks like the image below. Burn rate comes from the variable 'vBurnRate' which comes from dividing Dev % Burn by Dev % Complete. It is currently $(vBurnRate) in the expression. The colors are indicated by greater than or less than percentages. For example red is if the Burn Rate is <85% and also if it is >115%. It is yellow if it is 85-89% and also if it is 111-115%. It is green if it is 90-110%.
I am trying to make a button that can select, based on Burn Rate, if it is red, yellow, or green based on the percentage range above.