Min of multiple Columns

[#1]

Hi everybody,

Another day, another qlikview problem....

Thanks for everybody wi'll help me.

I want to get the minimum value of 4 columns : here is the example

Scenario 1 :

in 'F' Field (fields of excel) i want the minimum value  of {Seuil 1, Seuil 2, seuil 3, Seuil 4} but in this case i dont want 0 because all

'Seuil' values are not equal to zero. to summurise i want in this scenario the minmum value not null of {Seuil 1, Seuil 2, seuil 3, Seuil 4}

Scenario 2 :

In in this case, i want in 'F' field zero 'o' because all the Seuil 1=0, Seuil 2=0, seuil 3=0, Seuil 4=0} equal to zero

Hope that i explain my problem clearly

Thanks

[#2]

Oh i forget, i tried RangeMin like on the example but it doesnt work, thanks

[sasiparupudi1]

Please post your application here.

[anat]

in "Scenario 1 : " what will be the expected output ?

[#5]

0,5

[sasikanth]

HI,

Try some thing like this

if(  RangeMin(Column(1),Column(2),column(3),Column(4))<>'0',RangeMin(Column(1),Column(2),column(3),Column(4)))

or else

if( not isNull( RangeMin(Column(1),Column(2),column(3),Column(4)) ),RangeMin(Column(1),Column(2),column(3),Column(4)))

[#7]

hI Sasikanth_Narne,

I tried your syntax but in my expresion tab dosent know my flied name, any suggestion?

[florentina_doga]

HI,

Try some thing like this

    if(column(1)<>0,

        if(column(2)<>0,

            if(column(3)<>0,

                if(column(4)<>0,

                    rangemin(column(1),column(2),column(3),column(4))

                    ,rangemin(column(1),column(2),column(3)))

            ,if(column(4)<>0,

                rangemin(column(1),column(2),column(4))

                ,rangemin(column(1),column(2))))   

        ,if(column(3)<>0,

            if(column(4)<>0,

                rangemin(column(1),column(3),column(4))

                ,rangemin(column(1),column(3)))

        ,if(column(4)<>0,

                rangemin(column(1),column(4))

                ,rangemin(column(1),))))

    ,

    if(column(2)<>0,

            if(column(3)<>0,

                if(column(4)<>0,

                    rangemin(column(2),column(3),column(4))

                    ,rangemin(column(2),column(3)))

            ,if(column(4)<>0,

                rangemin(column(2),column(4))

                ,rangemin(column(2))))   

        ,if(column(3)<>0,

            if(column(4)<>0,

                rangemin(column(3),column(4))

                ,rangemin(column(3)))

        ,if(column(4)<>0,

                rangemin(column(4))

                ,0))))

[qlikmsg4u · Accepted solution]

Hi teneman,

with little tweak i'm able to do your requirement, I don't know if it is useful for you or not

what i did was replacing 0 value with Null string and finally doing RangeMin

[#10]

thanks a lot

that what i  want,, except that when all the seuil= Null i want Min= '0' and not '-'

Do you know how to get that ? thx