topic Re: Using Traffic Light Gauge with Date in QlikView

Using Traffic Light Gauge with Date

Sun, 07 Jun 2015 07:53:39 GMT

Hello Qlik Users,

I have scrolled through all discussion on this topic but none have been able to explain how date can be used with traffic light.

I have above data where I am trying to create a "single traffic light gauge" for date field. I have created "due date" as expression and named it as "traffic".

I want red light if "due date" is more than today's date and green otherwise.

What script should I add in below segment settings.

Re: Using Traffic Light Gauge with Date

kaushiknsolanki — Sun, 07 Jun 2015 08:00:46 GMT

HI,

Create a field in data model which is a difference between the due date and today.

Once you get this field, then use this field to get the traffic signal light.

If possible post the sample data.

Regards,

Kaushik Solanki

Re: Using Traffic Light Gauge with Date

Sun, 07 Jun 2015 08:12:51 GMT

Here is the qvw file.

Re: Using Traffic Light Gauge with Date

kaushiknsolanki — Sun, 07 Jun 2015 08:14:48 GMT

Rahul,

Kindly reload the application.

Cause it shows the script but no data.

Regards,

Kaushik Solanki

Re: Using Traffic Light Gauge with Date

Sun, 07 Jun 2015 08:28:28 GMT

Here is the data...

Ok, I followed above instruction now i can see red light but no green light..I have given lower bound as 0 for segment 1.

For traffic field i used formula as = today() - "due date"

Re: Using Traffic Light Gauge with Date

kaushiknsolanki — Sun, 07 Jun 2015 08:38:37 GMT

HI, Here is the solution.

Regards,

Kaushik Solanki

Re: Using Traffic Light Gauge with Date

Sun, 07 Jun 2015 08:56:26 GMT

Thanks Kaushik..It worked, just had to fine tune the gauge setting.

Re: Using Traffic Light Gauge with Date

MarcoWedel — Sun, 07 Jun 2015 09:16:27 GMT

Hi,

too late but maybe also helpful:

regards

Marco