Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Gauge of varios values together

I have done the goal and a set of stores

Would want to have a gauge for each.

If I do it with graphics separate out the store only selected in the filter and not all

and if I make a graph representation of gauge table, putting the maximum as an expression fails

any ideas?

1 Solution

Accepted Solutions
calvindk
Creator III
Creator III

It sounds to me like you want 4 gauges that do not change if you select a store.

That would be done by changing the expressions to the following:

sum({< store = {'tenda1'}

       >} value)

sum({< store = {'tenda2'}

       >} value)

sum({< store = {'tenda3'}

       >} value)

sum({< store = {'tenda4'}

       >} value)

View solution in original post

7 Replies
calvindk
Creator III
Creator III

I dont understand your problem. Can you explain and perhaps provide a screenshot?

Not applicable
Author

I think you want to do this:

http://community.qlik.com/message/357538#357538

Check the last Gysbter response.

Not applicable
Author

gauge1.jpg

gauge2.jpg

gauge3.jpg

If you select a store, get the gauge to your goal, but for a store.

and if I select the store in the filter get the data, but

I would want to have 4 at a time with the 4 shops and remove the filter from the shops

thanks

calvindk
Creator III
Creator III

It sounds to me like you want 4 gauges that do not change if you select a store.

That would be done by changing the expressions to the following:

sum({< store = {'tenda1'}

       >} value)

sum({< store = {'tenda2'}

       >} value)

sum({< store = {'tenda3'}

       >} value)

sum({< store = {'tenda4'}

       >} value)

Not applicable
Author

gauge4.jpg

correct! thanks

and to put the maximum value of that store for each gauge?

is the field Objetivo

calvindk
Creator III
Creator III

In the presentation tab try changing the max value to:

Sum({< store = {'tenda1'}

       >} Objetivo )

Not applicable
Author

gauge5.jpg

Perfect!!!

thanks!