Compare quarters (Previous & Current)

[#1]

Hi All,

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

Previous	Current		Image
Yellow	Yellow		Yellow
Red	Yellow		RedYellow
Green	Yellow		GreenYellow
Red	Red		Red
Yellow	Red		YellowRed
...	...		......

Thanks all

[#2]

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.

[#3]

i have reattached the file, custom images were loaded with bundle load..

any suggestions in writing the expression dathu.

[settu_periasamy]

Hi,

May be this link would be helpful.

Re: Traffic Light Indicators in straight table

how to change single light traffic light guage color in straighttable in qlikview?

[hariprasadqv]

Hi,

Currently there is no such kind of prebuild things. You create the combinational colored traffic lights as images and load them when ever it is required.

[#6]

Ya i done it.but need help in expression comparing the quarters with images.

[#7]

TQ

[jsingh71 · Accepted solution]

Hi Vamsi,

I created one qvw for this..find in attachment. Change the chart expression based on your condition.

and also change the path as per availability in your machine.

-Jai

[#9]

Thank you Jai