topic Re: Gauge chart - Traffic lights in QlikView

Gauge chart - Traffic lights

Anonymous — Tue, 30 Aug 2016 08:23:07 GMT

I need to keep the traffic lights RAG status independent of the selection in the multi list box.

Traffic lights need to show Red more than 2 services miss SLA, amber if 1 service misses SLA and green if no service misses SLA

Attaching is my file. I have used set analysis to make it independent of the Business Area, Application and Month but the RAG status still changes on selection of the values in the filter.

Can anybody please assist?

Re: Gauge chart - Traffic lights

mayankraoka — Tue, 30 Aug 2016 08:27:44 GMT

Remove 1 from ur expression as shown below:

count(aggr(if(1- (sum({<PERIOD_NAME=,[Business Area]=,Application=>}CUSTOMER_IMPACT_MINS)/sum({1<PERIOD_NAME=,[Business Area]=,Application=>}MINS_IN_MON))<=Only({1<PERIOD_NAME=,[Business Area]=,Application=>}[Theshold numeric]),[Service Id]),[Service Name]))

Regards,

Mayank

Re: Gauge chart - Traffic lights

Anonymous — Tue, 30 Aug 2016 08:30:26 GMT

Doesnt work with the removal of 1