topic Re: Auto Scale for Gauge is possible? in QlikView

Auto Scale for Gauge is possible?

Sun, 09 Sep 2012 14:24:26 GMT

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

Re: Auto Scale for Gauge is possible?

whiteline — Sun, 09 Sep 2012 18:18:02 GMT

Yes, its possible

Just type an expression that you want.

Re: Auto Scale for Gauge is possible?

Sun, 09 Sep 2012 20:44:56 GMT

Dear Whiteline,

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

What is the sample expression

regards

Re: Auto Scale for Gauge is possible?

whiteline — Mon, 10 Sep 2012 04:12:33 GMT

For example, for maximum scale:

=Max(Status)*1,1

and for minimum

=Min(Status)*0,9

I assumed that your field is named Status.

Re: Auto Scale for Gauge is possible?

Mon, 10 Sep 2012 19:30:07 GMT

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..

Re: Auto Scale for Gauge is possible?

Mon, 10 Sep 2012 19:47:41 GMT

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...

Re: Auto Scale for Gauge is possible?

whiteline — Tue, 11 Sep 2012 05:01:36 GMT

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.