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: 
uacg0009
Partner - Specialist
Partner - Specialist

How to find min value in different columns

Hi all,

Just like the subject, I have data like below:

How to find min value in different columns.PNG

 

The result that I want is :

How to find min value in different columns1.PNG


Thanks in advance.
I want to make it in the back-end script, you can use the attachment to be a sample.

Aiolos

Labels (3)
1 Solution

Accepted Solutions
Gysbert_Wassenaar

You can use the rangemin function:

LOAD
    ID,
    RangeMin(V1,V2,V3,V4) as MINVALUE
FROM
    ...source data...;

talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

You can use the rangemin function:

LOAD
    ID,
    RangeMin(V1,V2,V3,V4) as MINVALUE
FROM
    ...source data...;

talk is cheap, supply exceeds demand
albert_guito
Creator II
Creator II

I agree with Gysbert, RangeMin is the best solution.

You also can use it as expression in the table

RangeMin(V1,V2,V3,V4)
Ag+
uacg0009
Partner - Specialist
Partner - Specialist
Author

Hi Gysbert,

Really thanks for your reply, I always use rangesum in front-end, it's my first time to use rangemin.

Thanks.
Aiolos