I have 2 date fields. current and historical, and a dimension having 3 metric values (1=Yellow, 2=Red, 3= Green)
Need to Compare Current quarter and previous Quarter metric values. with 9 different colors as traffic lights.
Condition : if Current Qrt value is Yellow and previous Qtr is Red then image to show is half Yellow & Half red alike
Vamsi, Currently don't have multi color circle in built. You can get this type of gauges from web and download those gauges and load into Qlikview by using Bundle or Info Load.
You attached the excel file with only Current & history. We need to compare the Current & Previous History on the fly on UI. Use set analysis and change the value on fly to compare.