Qlik Community

Ask a Question

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
adoteykwame
Creator
Creator

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

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

2 Replies
jjfabian
Partner
Partner

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

adoteykwame
Creator
Creator
Author

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.