topic Re: How to let Gauge segment bounds work with a variable? in QlikView

How to let Gauge segment bounds work with a variable?

Suus — Wed, 22 Apr 2015 12:47:59 GMT

Hi,

I want to create a gauge meter with a variable 'norm', since KPI norm is not set yet.

No matter what I do I can not get the Gauge segment bounds to work with a variable.

I created a variable called vNorm which is connected to a input box.

This I try to encorporate in the lower bound of a segment.

Tried using =$(vNorm) or = vNorm, but it just won't work.

I see the segment requires a 0.7 (dot format) in stead of 0,7 (comma format) as is provided by my variable.

Could this be the culprit?

Do you know a way, or otherwise workaround to make this work?

Thanks!

Re: How to let Gauge segment bounds work with a variable?

Gysbert_Wassenaar — Wed, 22 Apr 2015 12:56:29 GMT

Yes, 0,7 wouldn't work as boundary value. You could try =num#(vNorm,'#,0',',','.').

Re: How to let Gauge segment bounds work with a variable?

jonathandienst — Wed, 22 Apr 2015 12:58:15 GMT

Yes, the numbers need to have a decimal point rather than a comma - although it may depend on your localisation settings.Why does your variable contain a comma?

HTH

Jonathan

Re: How to let Gauge segment bounds work with a variable?

Suus — Wed, 22 Apr 2015 13:20:26 GMT

That is the way we in Holland note decimals. So yes this is the way the DecimalSep is set.

Re: How to let Gauge segment bounds work with a variable?

Suus — Wed, 22 Apr 2015 14:08:31 GMT

The num# did not work

I figured it out myself.

Just made a second variable resulting in a textfield

vNorm2= '0.'& $(vNorm)

vNorm has input now of a % integer, e.g. 75 or 65

vNorm2 transfers it to 0.75 or 0.65

Strange thing is that gauge works with variable, but not with the same variable inserted as expression.

Anyway it works, and I am happy 😄