Nprinting Dynamic Name with variable

[mauvasco62]

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

[pradosh_thakur]

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)))

[mauvasco62]

Hi

it doesn't works.

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

Mauro

[pradosh_thakur]

please put a '=' in front of the variable

[mauvasco62]

Hi Pradosh.. thanks

... but it doesn't works correctly

Now appears the year but not the month.

Thanks anyway

Mauro

[pradosh_thakur · Accepted solution]

Hi Mauro,

sorry my bad.

try this

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

[mauvasco62]

Great!

Thanks

Have a nice day

Mauro