Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Min of multiple Columns

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}

qlik.PNG

Scenario 2 :

qlik2.PNG

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

11 Replies
anat
Master
Master

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

Not applicable
Author

Thx u so much, that work perfectly now,