topic Re: Minimum value. in QlikView

Minimum value.

Mon, 15 Oct 2012 15:40:12 GMT

Hi All,

i have a table in which a field Type which conatains two type of value X and y and in another column there is many numeric values but i want only latest and minimum values.

table is like

XandY, VALUE

X,12754

X,12721

X,12719

Y,4073

Y,4072

Y,3907

I want the X minimum value X-12719 and Y-3907

Please help

Thanks

Re: Minimum value.

fdelacal — Mon, 15 Oct 2012 15:44:09 GMT

SEE IF IT IS WAHT YOU NEED

Re: Minimum value.

Miguel_Angel_Baeyens — Mon, 15 Oct 2012 15:44:34 GMT

Hi,

Use the TOTAL qualifier within the expressions

Min(TOTAL <XandY> VALUE)

Hope that helps.

Miguel

Re: Minimum value.

kaushiknsolanki — Mon, 15 Oct 2012 15:46:28 GMT

You can try this expression.

Min({<XandY = {"X"}>}VALUE)

Only change X to Y for getting minimum value of Y.

Regards,

Kaushik Solanki

Re: Minimum value.

Mon, 15 Oct 2012 15:58:20 GMT

Thanks Both but i want two min values let me explain the table first it is some thing like

XandY, E, S, E-S

X, 123192, 110438, 12754

X, 123192, 110471, 12721

X, 123192, 110473, 12719

Y, 33167, 29094, 4073

Y, 33167, 29095, 4072

Y, 33167, 29260, 3907

In a straight table or pivot table it is look like this

i want to highlight or otherwise take the minimum values of XandY in the text box to show the minimum values like

X-12719

Y-3907

how this could be done please help.

Thanks

Re: Minimum value.

MayilVahanan — Mon, 15 Oct 2012 16:22:17 GMT

Please check the attached file..

Hope that helps

Re: Minimum value.

fdelacal — Mon, 15 Oct 2012 16:22:20 GMT

PROVE WITH THIS

=min(TOTAL <XandY>RangeMin(,[ES],))

REGARDS