topic Re: Nprinting Dynamic Name with variable in Qlik NPrinting

Nprinting Dynamic Name with variable

mauvasco62 — Tue, 05 Feb 2019 13:53:13 GMT

Dear friends,

i have a little (not for me) question.

i would like to use a variable in order to create a dynamic name into the final report (using Nprintg).

I wish it worked like this: every month I generate a report with data related the previous month and this value (previous month + year) must appear in the report name (for example... "ReportAlfa_2018_jan.xlsx").

I created a variable in qlik sense but it doesn't works.

The variable is : Period_name = Concat((year(ReferenceDate)),'-',(month(ReferenceDate)))

Where am I wrong?

Thanks for your support

Mauro

Re: Nprinting Dynamic Name with variable

pradosh_thakur — Tue, 05 Feb 2019 14:09:37 GMT

Reference Date contains many date. you may want to use ( today()-30 ) in the concat and then use the variable in dynamic naming
Concat((year(today()-30)),'-',(month(today()-30)))

Re: Nprinting Dynamic Name with variable

mauvasco62 — Tue, 05 Feb 2019 14:15:31 GMT

it doesn't works.

Now the report name is "REPORT ELESA_Concat((year(today()-30)),'-',(month(today()-30))).xlsx"

Mauro

Re: Nprinting Dynamic Name with variable

pradosh_thakur — Tue, 05 Feb 2019 14:19:44 GMT

please put a '=' in front of the variable

Re: Nprinting Dynamic Name with variable

mauvasco62 — Tue, 05 Feb 2019 14:31:02 GMT

Hi Pradosh.. thanks

... but it doesn't works correctly

Now appears the year but not the month.

Thanks anyway

Mauro

Re: Nprinting Dynamic Name with variable

pradosh_thakur — Tue, 05 Feb 2019 14:33:38 GMT

Hi Mauro,

sorry my bad.

try this

=(year(today()-30)) & '_' & (month(date(today()-30)))

Re: Nprinting Dynamic Name with variable

mauvasco62 — Tue, 05 Feb 2019 14:39:37 GMT

Great!

Thanks

Have a nice day

Mauro