Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

How to identify an empty variable?

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

2 Replies
Not applicable

How to identify an empty variable?

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?

Hi,

   You can also use the isnull() function. like

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

Regards,

Kaushik Solanki

Community Browser