Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
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

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to find min value in different columns

You can use the rangemin function:

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

talk is cheap, supply exceeds demand
3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: How to find min value in different columns

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
Contributor II

Re: How to find min value in different columns

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

Re: How to find min value in different columns

Hi Gysbert,

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

Thanks.
Aiolos