Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Presentation Tab:Null Symbol by default is "-" change to "0"
Thx u so much, that work perfectly now,