topic Handling null variable values in QlikView

Handling null variable values

Wed, 05 Jun 2013 10:15:45 GMT

Hi,

Im working with with several inputboxes, and each of one has a variable assigned to it. These inputboxes are made to insert numerical values but when the user delete the value in it I need to write a 0 value instead. I have tried to use the functions inNull(myVariable) or myVariable=null() to use some trigger but any of these work. If the variable is empty I can not make any thing with it (for example if I need the variable in some if expression, its not working).

Any ideas about how can I handle these "empty" variables?

Thanks!

Re: Handling null variable values

Wed, 05 Jun 2013 10:19:32 GMT

Could you not use in your expression smething like if(MyVariable = '' ... to handle the empty case ?

Re: Handling null variable values

ariel_klien — Wed, 05 Jun 2013 10:19:52 GMT

You can use if ()

something like that:

if($(myVariable)=null(),0,$(myVariable))

Ariel

Re: Handling null variable values

nirav_bhimani — Wed, 05 Jun 2013 10:23:47 GMT

Hi,

Try this expression,

If (len(myVariable)=0,0,myVariable)

Regards,

Nirav Bhimani

Re: Handling null variable values

Wed, 05 Jun 2013 10:31:08 GMT

Wow! Thank you very much for the quick answers!

In fact these expressions are the ones I have been using all the morning without success.

I have just tried this in the trigger, and it´s finally working!!

=if('$(vVar)'='', 0, $(vVar))

Thank you very much