topic Help with gauges (assigning a static max value) [newbie] in QlikView

Help with gauges (assigning a static max value) [newbie]

Sun, 27 Dec 2009 04:59:20 GMT

Hi all,

I can't figure out how to assign a value to a gauge (any object for that matters) that won't change when the user selects a field (listbox etc.).

I make the "arrow" in the gauge relevant to what is selected: avg(salary),
and the max value SHOULD stay the same (selected field shouldn't affect the value): 'avarage of all salaries'.

I'm guessing I have to assign a variable or something, but can't figure it out. Any help would be greatly appriciated.

Edit: Assigning max to avarage of all salaries might have sounded weird. I'm going to assign it to 'avarage of all salaries' * 2 [:)]

Help with gauges (assigning a static max value) [newbie]

Sun, 27 Dec 2009 16:42:36 GMT

Hi Skalis,

You can test as max the expression =Avg( {1} Total salary)

It's a set analysis. This expression is independant of your selection & your dimension.

For more info, refere to the help..

regards

Help with gauges (assigning a static max value) [newbie]

Sun, 27 Dec 2009 16:51:23 GMT

Thanks alot. Exactly what I was looking for.