topic Min of multiple Columns in QlikView

Min of multiple Columns

Fri, 12 Jun 2015 07:46:48 GMT

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

Re: Min of multiple Columns

Fri, 12 Jun 2015 07:50:23 GMT

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

Re: Min of multiple Columns

sasiparupudi1 — Fri, 12 Jun 2015 07:56:40 GMT

Please post your application here.

Re: Min of multiple Columns

anat — Fri, 12 Jun 2015 08:06:36 GMT

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

Re: Min of multiple Columns

Fri, 12 Jun 2015 08:08:28 GMT

0,5

Re: Min of multiple Columns

sasikanth — Fri, 12 Jun 2015 08:13:09 GMT

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

Re: Min of multiple Columns

Fri, 12 Jun 2015 09:14:54 GMT

hI Sasikanth_Narne,

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

Re: Min of multiple Columns

florentina_doga — Fri, 12 Jun 2015 09:39:29 GMT

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

Re: Min of multiple Columns

qlikmsg4u — Fri, 12 Jun 2015 09:47:51 GMT

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

Re: Min of multiple Columns

Fri, 12 Jun 2015 10:17:48 GMT

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

Re: Min of multiple Columns

anat — Fri, 12 Jun 2015 11:00:29 GMT

Presentation Tab:Null Symbol by default is "-" change to "0"

Re: Min of multiple Columns

Fri, 12 Jun 2015 11:22:45 GMT

Thx u so much, that work perfectly now,