# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

## Minimum value.

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

Thanks

6 Replies
Valued Contributor

## Re: Minimum value.

SEE IF IT IS WAHT YOU NEED

Employee

## Re: Minimum value.

Hi,

Use the TOTAL qualifier within the expressions

`Min(TOTAL <XandY> VALUE)`

Hope that helps.

Miguel

## Re: Minimum value.

You can try this expression.

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

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

Regards,

Kaushik Solanki

Not applicable

## Re: Minimum value.

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

Thanks

MVP

## Re: Minimum value.

Hi

Please check the attached file..

Hope that helps

Valued Contributor

## Re: Minimum value.

PROVE WITH THIS

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

REGARDS