topic Different traffic light bounds based on dimension value in QlikView

Different traffic light bounds based on dimension value

icaro_povoa — Mon, 17 Dec 2018 19:49:21 GMT

Dear all,

Could you please give me a hand on this?

I am trying to build a straight table on Qlikview, and one of the Expressions I created is a result in a traffic light format.

The demand is to have different lower and upper bounds based on different regions and KPIs.

Since now, Thank you very much

Re: Different traffic light bounds based on dimension value

jafari_ervin — Tue, 18 Dec 2018 07:10:28 GMT

you should set the lower bound for each traffic light chart then I think you can use from if statement.

if(territory='USA',1,if(territory='Europe',2)

then you should set the lower bound for two segment to 0 and 2.

please see the attachment.

Re: Different traffic light bounds based on dimension value

icaro_povoa — Tue, 18 Dec 2018 11:01:48 GMT

Thank you!

Was not exactly like this but open my mind for achieving the solution.

Follow what I did.

If(Avg({$<Territory={'A'},KPI={'1'}>}([Result]))>0,If(Avg({$<Territory={'A'},KPI={'1'}>}([Result]))<0.3,1,2)) &
If(Avg({$<Territory={'B},KPI={'2'}>}([Result]))>0,If(Avg({$<Territory={'B'},KPI={'2'}>}([Result]))<0.8,1,2)) &
If(Avg({$<Territory={'C'},KPI={'3'}>}([Result]))>0,If(Avg({$<Territory={'C'},KPI={'3'}>}([Result]))<1.3,1,2))

THANKS

Re: Different traffic light bounds based on dimension value

sibrulotte — Tue, 19 Mar 2019 19:28:47 GMT

Hi,
if someone is looking at this, there is DEFINITELY an easier way than the above formula.
instead of making a convoluted gauge setting minimum threashhold, simply make your actual expression an If forumla so that the result is either an 0,1 or 2.