topic Re: Expression works in one document, not another in QlikView

Expression works in one document, not another

Tue, 25 Mar 2014 15:15:17 GMT

Hi All,

Hope this is something easy, but it is driving me crazy. I have a variable, eLastDayOfMonth, set to this expression:

=date(floor(monthend(addmonths(Today(),-1))), 'YYYYMMDD')

I have a textbox that shows this variable in a document, with this expression:

=$(eLastDayOfLastMonth)

Works great. In one document. In another, I copied the same expressions and it displays a dash: -

What could cause this? Are there document settings that could affect this?

Thanks,

Blair

Re: Expression works in one document, not another

jpapador — Tue, 25 Mar 2014 15:17:35 GMT

Are the number of dates in one app the same as the other? If the expression has 2 possible values a text box will display a dash.

Re: Expression works in one document, not another

its_anandrjs — Tue, 25 Mar 2014 15:18:17 GMT

Hi,

Check there is no error while you copy and paste this expression in the variable =date(floor(monthend(addmonths(Today(),-1))), 'YYYYMMDD')

and also check = sign in the variable.

Hope this helps

Thanks & Reagrds

Re: Expression works in one document, not another

Tue, 25 Mar 2014 15:20:48 GMT

The expression isn't related to a date at all. It uses Today(). There are multiple date columns in both documents. And believe me, I have checked the syntax of both over and over. They are exactly the same.

Re: Expression works in one document, not another

jpapador — Tue, 25 Mar 2014 15:24:01 GMT

ah right my bad. Have you tried just =eLastDayOfLastMonth without the dollar sign expansion?

Re: Expression works in one document, not another

Tue, 25 Mar 2014 15:27:24 GMT

That doesn't work, and without the equals sign it of course shows the text of the expression. I'm thinking it has to be document related, as the expressions are identical and don't explicitly involve the data at all.

Re: Expression works in one document, not another

Tue, 25 Mar 2014 15:38:46 GMT

After having my coffee, I realized it was a typo with the actual variable names. Sorry to cause a ruckus over a silly mistake.