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

If with IsNull returning new value issue

Hi all,

New to Qlikview and having a slight issue with an expression.

My Expression is:

=if(isnull(COMPANY_USEBY_DATE), 'No Company Date', COMPANY_USEBY_DATE)

So basically, if there is a company date, show it to me, otherwise show me 'No Company Date'

I am sure that these are NULL values for the ones that have no dates, i have verified this in the DB.

When i try this, and i click on a company name (in it's own listbox), this expression (which is it's own list box) shows the Date if it's not null, and never shows 'No Company Date'.

For the ones with no dates, it just shows me a grey box with the dates in it, with nothing seleted.   I am trying to get it to either show The _one_ date in the box, or 'No Date' in the box.  Any assistance would be greatly appreciated!

Thanks!!

8 Replies
Not applicable
Author

Hi,

     Could you attach an example please.

Not applicable
Author

I can't send the actual data, made a quick sample in excel and imported into QV and same issue reproduced here.

Please let me know if the attached did not work.

Thank you Again!

Anonymous
Not applicable
Author

better do that in the script becuase in list box , the expressions will not work on null values. See the attached application. hope that helps

amien
Specialist
Specialist

I always use LEN(Field)  instead of ISNULL

Do you perhaps use a 32bit database and a 64bit Qlikview environment .. or the other way around?

Not applicable
Author

Interesting Vinay, i'll try this out on the bigger dataset from the DB, good idea!  Thanks!

Also, yes, i'm using the Force32 untill we make the switch over.

Anonymous
Not applicable
Author

Hi Drdevo , if that is helpful or correct can you please mark it helpful or correct so that it will be helpful for others when they see this post.

Not applicable
Author

Marked it as assumed answered... still need to work on the syntax for the query, but i think it will work.  Thanks again!

Anonymous
Not applicable
Author

ok great ..