Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Gauge with measure of specific value of the dimension

Hi

I would like put one Gauge that it only show a measure of one dimension value p.e. X.

I have specified in the expresion of measure with an IF, but if there is only the X filter, it is ok, but if i don`t have filters o I have X and oter more, the Gauge don't show anything.

Thank you. Gabriel

1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

use the following expressions in your gauge

for DimA = X

     =AVG({<Dim-A=,Dim-A={'X'}>} MEA-A)

DimA = Y

    =AVG({<Dim-A=,Dim-A={'Y'}>} MEA-A)

DimA = Z

    =AVG({<Dim-A=,Dim-A={'Z'}>} MEA-A)


and Dimension  = Dim-A

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

5 Replies
vinieme12
Champion III
Champion III

Sorry Gabriel, couldn't understand the scenario or problem here.

Do you want your gauge to calculate only if particular values are selected??

Can you post your dimension expression , your calculation expression and screenshots to explain what you need, also confirm what field you are filtering on

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

Hi Vineeth, thank you, I am going to try explain better. I will use one example

I have these data

DIM-ADIM-BMEA-AMEA-B
XM16
XM26
XM34
YM27
YM58
YN59
ZN40
ZN38
ZN44

I like have one independent gauge for each X, Y & Z DIM-A with the avg of MEA-A and always show the result independently if there are filters o select something.

I have proved with use function if in measure calculate, and I have also proved with put condition in data handling. But it doesn't work like I want.

I attached the example result

Screenshot (1).png

vinieme12
Champion III
Champion III

use the following expressions in your gauge

for DimA = X

     =AVG({<Dim-A=,Dim-A={'X'}>} MEA-A)

DimA = Y

    =AVG({<Dim-A=,Dim-A={'Y'}>} MEA-A)

DimA = Z

    =AVG({<Dim-A=,Dim-A={'Z'}>} MEA-A)


and Dimension  = Dim-A

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

Thank you.

Not applicable
Author

Hi Vineeth .Similarly that.

If I need use a specific number (that I know calculate, it will be like a specific number value, more or less like a constant) into expression to calculate a measure.

How can I do?

Thank you.