Different traffic light bounds based on dimension value

[icaro_povoa]

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

[jafari_ervin · Accepted solution]

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.

[icaro_povoa]

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

[sibrulotte]

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.