topic How to identify an empty variable? in QlikView

How to identify an empty variable?

Sun, 26 Jun 2011 14:17:48 GMT

Hi,

I have a variable named "MaxNumber". I want to create a chart expression like:

IF $(MaxNumber) is empty then... else...

What is the exact syntax? I tried to use '' or "" or ' ' but it doesn't idntify the empty variable. Also, ISNULL() doesn't recognize "empty" as "Null"...

Thanks,

Doron

How to identify an empty variable?

Sun, 26 Jun 2011 14:30:13 GMT

Hello Doron,

try the following instead of empty and so on. (Note the two '' around the Var):

If( Len( '$(Variable1)') > 0, . . .)

Regards,

Roland

How to identify an empty variable?

kaushiknsolanki — Sun, 26 Jun 2011 17:20:55 GMT

Hi,

You can also use the isnull() function. like

if(isnull('$(Variable1)'),'Empty','Has Value')

Regards,

Kaushik Solanki