Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Compare quarters (Previous & Current)

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 RedYellow.png

 

PreviousCurrentImage
YellowYellowYellow
RedYellowRedYellow
GreenYellowGreenYellow
RedRedRed
YellowRedYellowRed
............

Thanks all

1 Solution

Accepted Solutions
jsingh71
Partner
Partner

Hi Vamsi,

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

pi.png

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

-Jai

View solution in original post

8 Replies
Not applicable
Author

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.

Not applicable
Author

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

any suggestions in writing the expression dathu.

hariprasadqv
Creator III
Creator III

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.

Not applicable
Author

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

Not applicable
Author

TQ

jsingh71
Partner
Partner

Hi Vamsi,

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

pi.png

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

-Jai

View solution in original post

Not applicable
Author

Thank you Jai