how to load mathematical operators?

[#1]

hi,

i have a request about doing dynamic gauges

and i need to load data like this:

Client_id	Red	Yellow	Green
1001	>1:<=30	>35:<=60	>=65:<=90
1002	<=40	>40:<=90	>90
1003	>20:<50	>=50:<85	>=85:100

how i can do this??

thanks,

Carlos

[morgankejerhag · Accepted solution]

Three could be more than one way of solving this. My example requires that there is both high and low limits for each color. I am not sure how you will use them, but the Gauge in QlikView only uses lower limits.