topic Min(val1,val2) how? in QlikView

Min(val1,val2) how?

Tue, 28 Jun 2011 08:30:41 GMT

I'm building a gauge where I want the the minimum value to be dynamic. Basicly I want it to do the following:

MIN(TARGET, REALIZATION) -2

But that doesn't seem to work. Is there an on the fly MIN(val1, val2) way to work?

Thanks!

Min(val1,val2) how?

kaushiknsolanki — Tue, 28 Jun 2011 08:32:33 GMT

Hi,

Can you please describe in detail what you are trying to do..?

Regards,

Kaushik Solanki

Min(val1,val2) how?

Tue, 28 Jun 2011 08:36:14 GMT

In a gauge you can set a min and a max value.

Standard a gauge runs from 0 to 1 (0 to 100%).

Since my targets are around 99.5% I want a higher Minimum value in the gauge, so I want the start value in the gauge to be dynanmic. Sometime however the result (REALIZATION) value, which is calculated in a variable is lower than my BUDGET value . So I want the MIN value of the gauge to be the lowest of BUDGET and REALIZATION minus 2%. Hence I seek the lowest of the value min( $(Realization), $(Target) ).

Min(val1,val2) how?

kaushiknsolanki — Tue, 28 Jun 2011 08:38:26 GMT

HI,

Try this.

(Min($(Realization)) - Min($(Target))) -2

Regards,

Kaushik Solanki

Min(val1,val2) how?

IAMDV — Tue, 28 Jun 2011 08:41:45 GMT

Hi,

Have you tried using RangeMin function?

Thanks - DV

Min(val1,val2) how?

Tue, 28 Jun 2011 08:45:08 GMT

Thanks! RangeMin() Solves it! I didn't know that command

Min(val1,val2) how?

IAMDV — Tue, 28 Jun 2011 08:51:18 GMT

Excellent!