Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Hello Doron,

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

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

Regards,

Roland

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

   You can also use the isnull() function. like

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!