Creating a Gauge Chart to Reflect Upcoming Events Based on Todays Date

Anonymous — Wed, 24 Sep 2014 10:08:15 GMT

I need to create a gauge chart to reflect upcoming events based on todays date. I am sure it is something simple but for some reason I cant wrap my brain around it. Any help would be greatly appreciated. Here is an example.

The clients sends their customer a certain letter based on a renewal date. So for example if the renewal date is Jan. 1, 2015 they would send a letter at 90 days, 60 days, and 30 days of that date. I need a gauge that would reflect the following.

Green: Renewal date is greater than 90 days of todays date.

Yellow: Renewal date is 90 to 61 days of todays date.

Orange: Renewal date is 60 to 31 days of todays date.

Red: Renewal date is 30 days or past todays date.

Thanks,

Chris

Re: Creating a Gauge Chart to Reflect Upcoming Events Based on Todays Date

Gysbert_Wassenaar — Wed, 24 Sep 2014 11:28:33 GMT

You could use a straight table, add customer as dimension and and expression that returns a reference to a built-in image:

if([Renewal date]-today()>90, 'qmem://<bundled>/BuiltIn/led_g.png',

if([Renewal date]-today()>60, 'qmem://<bundled>/BuiltIn/led_y.png',

if([Renewal date]-today()>30, 'qmem://<bundled>/BuiltIn/led_0.png', 'qmem://<bundled>/BuiltIn/led_r.png')))

Set the Representation option to Image and the Image Formatting setting to Keep Aspect.

If that's not what you need, please provide more details and some sample data.

topic Creating a Gauge Chart to Reflect Upcoming Events Based on Todays Date in QlikView

Creating a Gauge Chart to Reflect Upcoming Events Based on Todays Date

Re: Creating a Gauge Chart to Reflect Upcoming Events Based on Todays Date