Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
uacg0009
Partner
Partner

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

View solution in original post

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
Partner
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