topic Re: Null/missing/blank Value Treatment in App Development

Null/missing/blank Value Treatment

davidmoises — Sat, 16 Nov 2024 04:52:29 GMT

hello everyone

First of all I apologize if this message is not correctly located within the forum locations.

I'm trying to treat a field that includes some values with a format that I can't recognize, as shown in the following picture.

this is the "Importe" field, which I need to take the value '0' and which I can deal with from the application view section. the problem is that I need to do this transformation at script level.

so far I have tried to do it through sentences of the type:

if(isnull(Importe), 0, Importe)
if(isnull, '0', Importe)
if(isnull, '', Importe)
if(isnull, ' ', Importe)
(...)

*I have also considered the possibility of it being a text type and I have tried to transform it, but it still cannot be identified.

none of them work, I appreciate any idea or suggestion, greetings

Re: Null/missing/blank Value Treatment

Vegar — Fri, 23 Aug 2019 21:21:46 GMT

If Importe is a numeric field you can use the alt() function.

Try this:

ALT(Importe,0)

Re: Null/missing/blank Value Treatment

davidmoises — Mon, 26 Aug 2019 12:58:08 GMT

First of all, thank you for answering. I have tried the solution you propose, but without success. Apparently and as I commented in my first message the problem lies in the type of elements in question that do not seem to be null, as can be seen below:

I still can't find a solution to the problem.

Re: Null/missing/blank Value Treatment

marcus_sommer — Mon, 26 Aug 2019 14:07:56 GMT

It depends on the cause of NULL what you may do to get your wanted visualization. The best explanation for it is:

NULL-handling-in-QlikView

- Marcus