Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

SEE IF IT IS WAHT YOU NEED

Miguel_Angel_Baeyens

Hi,

Use the TOTAL qualifier within the expressions

Min(TOTAL <XandY> VALUE)

Hope that helps.

Miguel

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

You can try this expression.

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

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

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

MayilVahanan

Hi

Please check the attached file..

Hope that helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
fdelacal
Specialist
Specialist

PROVE WITH THIS

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

REGARDS