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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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,