Qlik Community

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

Please help

Thanks

6 Replies
fdelacal
Valued Contributor

Re: Minimum value.

SEE IF IT IS WAHT YOU NEED

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

how this could be done please help.

Thanks

Re: Minimum value.

Hi

Please check the attached file..

Hope that helps

fdelacal
Valued Contributor

Re: Minimum value.

PROVE WITH THIS

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

REGARDS

Community Browser