Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!!
Hi,
Could you attach an example please.
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!
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
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?
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.
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.
Marked it as assumed answered... still need to work on the syntax for the query, but i think it will work. Thanks again!
ok great ..