topic Re: How to evaluate a variable in NPrinting? in Qlik NPrinting

How to evaluate a variable in NPrinting?

jblomqvist — Wed, 24 May 2017 15:26:32 GMT

Hi there,

I have a variable like this:

Variable name: vYear

Expression: Year(AddYears(Max(Date),-1))

When I put this Variable in NPrinting I do <vYear> it gives me the expression above, what I want is the result of the expression.

How do I do this?

Re: How to evaluate a variable in NPrinting?

Anil_Babu_Samineni — Wed, 24 May 2017 16:39:58 GMT

May be call it as [vYear]

Re: How to evaluate a variable in NPrinting?

Lech_Miszkiewicz — Thu, 25 May 2017 00:03:37 GMT

you need to evaluate your expression - which means you need to have "="ign in front of your expression:

like:

Expression: =Year(AddYears(Max(Date),-1))

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: How to evaluate a variable in NPrinting?

kdmarkee221 — Fri, 02 Jun 2017 15:19:27 GMT

Can you clarify this post? Is the logic done in the script portion and if so, what does that look like? I'm currently picturing or assuming the variable in the script is like this:

SET vYear = Year(AddYears(Max(Date),-1));

Thanks.

Re: How to evaluate a variable in NPrinting?

kdmarkee — Fri, 02 Jun 2017 16:08:01 GMT

I think I figured out what was meant by the "=". I did this in the Variable editor and not the script, but maybe you can do it in both places...I'm not sure.

Re: How to evaluate a variable in NPrinting?

Lech_Miszkiewicz — Sat, 03 Jun 2017 00:45:33 GMT

you can do it in both places. In script however i think you will have to use LET statement and apostrophies

like:

LET vYear = '=Year(AddYears(Max(Date),-1))';

Re: How to evaluate a variable in NPrinting?

kdmarkee — Sat, 03 Jun 2017 15:00:48 GMT

That's what I was looking for; I'll have to try that. Thanks.

Re: How to evaluate a variable in NPrinting?

Lech_Miszkiewicz — Sun, 04 Jun 2017 23:19:11 GMT

see how it goes.. cheers Lech