topic Re: Date in Label Nprinting in Qlik NPrinting

Date in Label Nprinting

Anonymous — Wed, 18 Oct 2017 09:38:15 GMT

hi,

i want to insert a function:

date( today()-2 , 'dd MMMM yyyy' )

in PixelPerfect label. It's possibile?

i've .qvw source also and i just create same expression as variable vToday.

How can i use it in a Label ?

Thank you

Re: Date in Label Nprinting

Ruggero_Piccoli — Wed, 18 Oct 2017 14:58:01 GMT

Add it into the Variables node, then drag and drop into the template.

Best Regards,

Ruggero

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

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: Date in Label Nprinting

Anonymous — Wed, 18 Oct 2017 15:10:07 GMT

It dosen't works 'cause it display only a formula (expression)

Re: Date in Label Nprinting

Stephen_Jasionowski — Wed, 18 Oct 2017 18:40:53 GMT

Did you bind the formula/variable to the label object?

Re: Date in Label Nprinting

Lech_Miszkiewicz — Thu, 19 Oct 2017 00:34:11 GMT

it is because you want your date to evaluate before beeing pass to template

If it is in variable - put "=" sign before your expression, or use the same on template level and create NPrinting formula instead.

cheers

Lech

Re: Date in Label Nprinting

Ruggero_Piccoli — Mon, 23 Oct 2017 08:35:54 GMT

Hi,

Use this formula instead:

=text(date( today()-2 , 'dd MMMM yyyy' ))

text() will force the output to be a string so PixelPerfect will interpret it correctly.

Best Regards,

Ruggero

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

Re: Date in Label Nprinting

Anonymous — Mon, 23 Oct 2017 09:08:45 GMT

Grazie Ruggero

It works!