Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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