Using Traffic Light Gauge with Date

[#1]

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.

[kaushiknsolanki]

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

[#3]

Here is the qvw file.

[kaushiknsolanki]

Rahul,

Kindly reload the application.

Cause it shows the script but no data.

Regards,

Kaushik Solanki

[#5]

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"

[kaushiknsolanki · Accepted solution]

HI, Here is the solution.

Regards,

Kaushik Solanki

[#7]

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

[MarcoWedel]

Hi,

too late but maybe also helpful:

regards

Marco