topic Re: Compare quarters (Previous & Current) in QlikView

Compare quarters (Previous & Current)

Sun, 21 Jun 2015 15:27:07 GMT

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

Re: Compare quarters (Previous & Current)

Sun, 21 Jun 2015 16:41:29 GMT

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.

Re: Compare quarters (Previous & Current)

Mon, 22 Jun 2015 04:43:43 GMT

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

any suggestions in writing the expression dathu.

Re: Compare quarters (Previous & Current)

settu_periasamy — Mon, 22 Jun 2015 04:57:43 GMT

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?

Re: Compare quarters (Previous & Current)

hariprasadqv — Mon, 22 Jun 2015 05:17:51 GMT

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.

Re: Compare quarters (Previous & Current)

Mon, 22 Jun 2015 05:52:28 GMT

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

Re: Compare quarters (Previous & Current)

Mon, 22 Jun 2015 05:53:13 GMT

Re: Compare quarters (Previous & Current)

jsingh71 — Mon, 22 Jun 2015 05:57:15 GMT

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

Re: Compare quarters (Previous & Current)

Mon, 22 Jun 2015 19:39:57 GMT

Thank you Jai