topic Re: Display Weekname in NPrinting file name in Qlik NPrinting

Display Weekname in NPrinting file name

AndersGS — Wed, 25 Sep 2019 18:40:54 GMT

Hi,

I have a report scheduled Mondays that includes last weeks data. In the file name, I'd like to include the name of last week, i.e. for example "Weekly Sales Report 2019/38".

I have this variable set up in QlikView:

SET vWeekNameReport =weekname(today()-1)

This variable is added to the report Dynamic name/Qlik variable

But the file displays the content of the variable rather than the week name: "Weekly Sales Report_weekname(today()-1)"

We are running NPrinting 19 February 2019 SR1 and QlikView 11.20 SR 18.

Thanks in advance

Regards,
Anders

Re: Display Weekname in NPrinting file name

Lech_Miszkiewicz — Tue, 24 Sep 2019 08:10:57 GMT

Hi,

This topic is very well documented with youtube tutorials and official documentation. Please read help to understand why you get a content of variable instead of actual evaluated value - link below.

https://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/ReportsDevelopment/Work-with-variables.htm

and also here

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Using-Variables-in-the-Email-Subject/td-p/1553437

also here

https://www.youtube.com/watch?v=3HFdrqsbQlk

you are missing the most important thing: "="(equal sign) in front of your variable so it can evaluate!!!

Re: Display Weekname in NPrinting file name

Lech_Miszkiewicz — Tue, 24 Sep 2019 09:40:51 GMT

Just to follow up - my examples show you how to use variable in message subject etc.. but princliple is the same as variable needs to be evaluated....

Re: Display Weekname in NPrinting file name

AndersGS — Tue, 24 Sep 2019 10:31:30 GMT

Thanks Lech! And thanks for the examples.

The = sign is present in the variable "=weekname(today()-1)" . I have tested using a simple date variable like
"= Date(Floor(Now()))" and it works. I'm thinking it's a problem with evaluating the WeekName syntax in my current variable (or MonthName/YearName)?

What do you think?

Re: Display Weekname in NPrinting file name

AndersGS — Tue, 24 Sep 2019 10:44:16 GMT

Could be the fact that WeekName returns 2019/38 which would be a non supported file name. How could I amend the variable to change the "/" to a "-"?

Re: Display Weekname in NPrinting file name

Lech_Miszkiewicz — Tue, 24 Sep 2019 10:48:17 GMT

How about replace($(variable),’/‘,’-‘)

Re: Display Weekname in NPrinting file name

AndersGS — Tue, 24 Sep 2019 14:55:52 GMT

Thanks. I created these two variables:

SET vWeekName_LW = WeekName$(vReloadDate)-1;
SET vReport_LW = replace($(vWeekName_LW),'/','-w');

but it still does not do the trick unfortunately:

Output pdf file name: Weekly Report_replace(WeekName2019-09-24-1,'_','-w').pdf
what I want to see here is rather Weekly Report_2019-w39.pdf

any ideas?

Re: Display Weekname in NPrinting file name

Lech_Miszkiewicz — Tue, 24 Sep 2019 21:52:33 GMT

Hi,

this means that you are putting = sign in front of first variable and not the second variable

simply use one variable for this exercise and again - note the "=" sign which you did not have in front of your variable expression

SET vWeekName_LW = "=Replace(Text(WeekName(Floor(ReloadTime())-1)),'/','-')";

Re: Display Weekname in NPrinting file name

AndersGS — Wed, 25 Sep 2019 11:09:27 GMT

Worked perfect, thanks Lech!

Re: Display Weekname in NPrinting file name

Lech_Miszkiewicz — Wed, 25 Sep 2019 12:42:53 GMT

No worries mate!