Surpress null value

davinfrost — Wed, 25 Nov 2020 16:16:04 GMT

hi guys,

is there any way to surpress null value on Text Object?

='Total So Number'&' = '&count(distinct [So Number Edit])
& ' Total Invoice = '&Count(DISTINCT([Total SO No]))

there is a null value on field [Total SO No]

many thanks..

Re: Surpress null value

sasikanth — Tue, 25 Jun 2019 06:43:33 GMT

Hi,

Try below code,

='Total So Number'&' = '&count(distinct [So Number Edit])
& ' Total Invoice = '&Count( distinct if (not isnull ([Total SO No]) OR length([Total SO No])>0 , [Total SO No]))

='Total So Number'&' = '&count(distinct [So Number Edit])
& ' Total Invoice = '&Count( DISTINCT {< [Total SO No] -={'-'}>} [Total SO No])

Thanks,

Sasi

topic Re: Surpress null value in QlikView

Surpress null value

Re: Surpress null value