topic Re: How do i make the value in a gauge constant to some specific dimensions??? in QlikView

How do i make the value in a gauge constant to some specific dimensions???

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

Suppose i have a gauge as an object and i do not want the the value to change of the gauge to change whilst i click on specific dimensions. What expression can i write to effect this instance with three or more dimension.

Thanks

Re: How do i make the value in a gauge constant to some specific dimensions???

jjfabian — Mon, 05 Mar 2012 14:30:33 GMT

First of all, you could detach the entire chart.

Second, you could try set analysis. You have to ignore your specific dimensions.

E.g. something like

sum({$<Dim1=, Dim2=, Dim3=>} Sales) / sum({$<Dim1=, Dim2=, Dim3=>} UnitCount)

or whatever your actual formula is. Important part is the {$<Dim1=, Dim2=, Dim3=>} part. By just putting a = for each dimension you are telling set analysis to ignore selections in that dimension.

edited by Jakob Fabian

How do i make the value in a gauge constant to some specific dimensions???

Anonymous — Wed, 07 Mar 2012 09:52:57 GMT

Hi there,

Thanks for sharing the was very helpful indeed but i had a red undulating line even though the expression reads OK.Should i be worried about that?

Kindly find attached a screen shot.