topic How to find min value in different columns in QlikView

How to find min value in different columns

uacg0009 — Sat, 16 Nov 2024 21:47:06 GMT

Hi all,

Just like the subject, I have data like below:

The result that I want is :

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

Aiolos

Gysbert_Wassenaar — Tue, 04 Dec 2018 07:27:25 GMT

You can use the rangemin function:

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

albert_guito — Tue, 04 Dec 2018 10:03:44 GMT

I agree with Gysbert, RangeMin is the best solution.

You also can use it as expression in the table

RangeMin(V1,V2,V3,V4)

uacg0009 — Wed, 05 Dec 2018 08:33:07 GMT

Hi Gysbert,

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

Thanks.
Aiolos