topic Re: Traffic lights gauge for data refresh indicator in QlikView

Traffic lights gauge for data refresh indicator

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Hope all are doing good.

I need help on creating a traffic light gauge chart to indicate data refresh.

If the data refreshed to day i have to display green light and if the data refreshed yesterday i need to display Amber and for before yesterday i need to display red light.

To achieve this I have taken ReloadTime() as expression and i have taken three segments for green and amber and red.

For scale i have considered 0 as min and Today() as Max value.Green lower bound is Today() and for amber lower bound is Today()-1 and 0 is lower bound for red.

But i am not able to achieve the functionality.

Any suggestions are highly appreciated.

Thanks,

Nani

Re: Traffic lights gauge for data refresh indicator

vikasmahajan — Mon, 28 Nov 2016 07:14:19 GMT

see this

Pivot table with a traffic light field

Re: Traffic lights gauge for data refresh indicator

Anil_Babu_Samineni — Mon, 28 Nov 2016 07:17:05 GMT

Try to take gauge expression Like below

=If(Today() = ReloadTime(), Green(), If(Today() = ReloadTime()-1, Amber(), If(Today() = ReloadTime()-2, Red(), Yellow())))

Re: Traffic lights gauge for data refresh indicator

Mon, 28 Nov 2016 07:27:58 GMT

Hi Anil,

Thanks for the response.

If have tried your solution but not able to achieve the functionality. What are the segment boundaries that we need to take.

Thanks,

Nani

Re: Traffic lights gauge for data refresh indicator

Mon, 28 Nov 2016 07:28:48 GMT

Hi Vikas ,

i need to show traffic lights to indicate data refresh date not in pivot table.

Thanks,

Nani

Re: Traffic lights gauge for data refresh indicator

tamilarasu — Mon, 28 Nov 2016 08:17:13 GMT

Hi Nani,

Like attached?

Re: Traffic lights gauge for data refresh indicator

Mon, 28 Nov 2016 08:24:25 GMT

Hi Nagaraj,

i am not able to open the application. can you pls explain the logic that you have incorporated?

Thanks,

Nani

Re: Traffic lights gauge for data refresh indicator

tamilarasu — Mon, 28 Nov 2016 08:41:05 GMT

Hi Nani,

Kindly check the scrrenshots in the below word document.

Re: Traffic lights gauge for data refresh indicator

Tue, 29 Nov 2016 05:29:45 GMT

Thanks Nagaraj. Exactly that is what i am looking for.

Regards,

Nani