topic Re: If with IsNull returning new value issue in QlikView

If with IsNull returning new value issue

Tue, 25 Sep 2012 14:58:00 GMT

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!!

Re: If with IsNull returning new value issue

Tue, 25 Sep 2012 15:02:14 GMT

Hi,

Could you attach an example please.

Re: If with IsNull returning new value issue

Tue, 25 Sep 2012 15:29:01 GMT

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!

Re: If with IsNull returning new value issue

Anonymous — Tue, 25 Sep 2012 15:58:47 GMT

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

Re: If with IsNull returning new value issue

amien — Tue, 25 Sep 2012 16:27:18 GMT

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?

Re: If with IsNull returning new value issue

Tue, 25 Sep 2012 16:37:06 GMT

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.

Re: If with IsNull returning new value issue

Anonymous — Tue, 25 Sep 2012 17:17:02 GMT

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.

Re: If with IsNull returning new value issue

Tue, 25 Sep 2012 17:39:51 GMT

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

Re: If with IsNull returning new value issue

Anonymous — Tue, 25 Sep 2012 17:41:50 GMT

ok great ..