Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: If with IsNull returning new value issue

Hi,

     Could you attach an example please.

Not applicable

Re: If with IsNull returning new value issue

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!

vinay_bangari
Valued Contributor III

Re: If with IsNull returning new value issue

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
Valued Contributor

Re: If with IsNull returning new value issue

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

Re: If with IsNull returning new value issue

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.

vinay_bangari
Valued Contributor III

Re: If with IsNull returning new value issue

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

Re: If with IsNull returning new value issue

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

vinay_bangari
Valued Contributor III

Re: If with IsNull returning new value issue

ok great ..

Community Browser