Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

lornafnb
Valued Contributor

Guage

hi guys

pfa

I am trying to dynamically assign the Lowerlimits of the guage...but I'm not getting it right.

the limit is where every section STARTS as I understand, and I dont want the user to have to update the values every time.

any suggestions?

another option would probably be do express the amount as a percentage - so that the limits are always known (between 0 and 100)...

thanks guys

1 Solution

Accepted Solutions
miguelbraga
Valued Contributor III

Re: Guage

Is this what you're looking for?

5 Replies
miguelbraga
Valued Contributor III

Re: Guage

Hey there,

Have you tried using {$} in your lower limit?

Something like this for min:

=sum({$<Exposure = {$(vLowerLimit1)}>} Exposure)

For max:

=sum({$<Exposure = {$(vLowerLimit2)}>} Exposure)

Assing 0 to min for 0% equivalent of your min and for 100% to max, then in your expression make something like this:

=value/ (sum({$<Exposure = {$(vLowerLimit2)}>} Exposure))


Don't forget to make the Numbers as with 2 decimals and check percentage mode

Thanks,

MB

miguelbraga
Valued Contributor III

Re: Guage

Is this what you're looking for?

lornafnb
Valued Contributor

Re: Guage

Thank you Braga

lornafnb
Valued Contributor

Re: Guage

what does this achieve?

=$(vLowerLimit1) / $(vLowerLimit2)

miguelbraga
Valued Contributor III

Re: Guage

This expression:

min / max

A gauge chart like you want needs to express a percentage

Community Browser