topic Re: Suppress Null value in Text box in QlikView

Suppress Null value in Text box

abhaysingh — Thu, 25 Feb 2016 17:35:42 GMT

hi,

how to remove null value in text box??

i need to show max(temp) for Sensor ID, right now there are few null values in it so it is showing max of temp of null value.. which is wrong..

i did not want to show null value how i can handle it in text box?

pls suggest?

sunny_talwar — Thu, 25 Feb 2016 17:43:29 GMT

May be this:

Max({<[Sensor ID] = {"=Len(Trim([Sensor ID])) > 0"}>}temp)

swuehl — Thu, 25 Feb 2016 17:43:31 GMT

Maybe like

max({<SensorID = {"*"}>}temp)

Gysbert_Wassenaar — Thu, 25 Feb 2016 17:44:18 GMT

Try this: max({<[Sensor ID]={'*'}>}temp)

Chanty4u — Thu, 25 Feb 2016 17:44:20 GMT

can u shre sample?

engishfaque — Fri, 26 Feb 2016 06:23:28 GMT

Deara Abhay,

Here it's,

Max({<[Sensor ID] -= {'Null()'}>} temp)

Kind regards,

Ishfaque Ahmed