Auto Scale for Gauge is possible?

[#1]

Dear All,

I want to use a Gauge for "Revenue Status"

in the beginning I set the Gauge Scale to (min: -100  between max : 100)

Status 1

2012 value "10.000 US$" and

2013 value "20.000 US$ and  (what if)

Chart is OK.. It indicates 100%...... But

When Status 2

2012 value "10.000 US$" and

2013 value "30.000 US$ and

Chart indicates 100% but it istn correct as you know...

İf I set the Gauge Scale to  (min: -1000  between max : 1000) then needle can bu display the right point but too small area for other status...

İs there any automatic Scaling method for (Min, max valuee) for calculated 2013 projection...

Regards

John

[whiteline]

Yes, its possible

Just type an expression that you want.

[#3]

Dear Whiteline,

Can you help me with this please... I am new user of QV..

What is the sample expression

regards

[whiteline · Accepted solution]

For example, for maximum scale:

=Max(Status)*1,1

and for minimum

=Min(Status)*0,9

I assumed that your field is named Status.

[#5]

Dear whiteline...

Your answer seems right if i use one filed which named "Status" ... for expiression ....

But my 2012 and 2013 values are comes from diffrent expiression...

For examle :

2012 revenue is ... : sum(qty*price1)

2013 revenue is ... : sum(qty*price2*R)

I tried for min-max scale of gauge according your answer :

For Min .....: =Min(sum(qty*price1))*0,9

For Max.....: =Max(sum(qty*price2*R))*1,1

But it doest work properly...I 've got just "0" time to time "bad min*max value"

I need your idea...

Regards..

[#6]

Dear Whiteline...

Thank you your answer... its OK i checked my expression and saw a forgatton "(" sign...

And...

I removed min max commands from your answer..

like :

Min value in Presentation Tab  : -Sum(....)     on yhe front of expression is "-"

Max value in Presentation Tab :   Sum (...)

Your answer is working...

Regards...

[whiteline]

Hi northbridge.

It's hard to make something useful by bruteforcing

Ta make this expression work

=Min(sum(qty*price1))*0,9

you should explain QlikView how to eveluate it.

When you use it in Chart you have some dimensions, so that =qty*price1 can be calculcated as there is only one qty and only one price for each dimension value. And so on with Sum and Min.

When you use expression in Gauge Min/Max there are no dimensions and it's calculated on a whole set of your data. There are a lot of qty's and price1's, so even =qty*price1 gives null().

To make it calculated you should explain how to do it.

For example:

=Min(aggr(sum(qty*price1), [ProductID]))*0,9

I assumed that we have just ProductID field and for each there are qty and price1.

So I ask QV first calculate a sum(qty*price1) for each product and then find minimum from the array of that summs.