topic Re: NPrinting Dynamic Report Naming Using Filter Value in Qlik NPrinting

NPrinting Dynamic Report Naming Using Filter Value

baarathi — Sat, 16 Nov 2024 04:35:17 GMT

I have NPrinting Report named Sales Report, I have applied User Level Filter so as to Send Sales Report based on Country.

Filter for User1: CountryName = India and User2: CountryName = Australia. Is it possible to deliver the reports like below format.

User1 - Sales Report for India

User2 - Sales Report for Australia

Any suggestions to get the above output?

Re: NPrinting Dynamic Report Naming Using Filter Value

Lech_Miszkiewicz — Fri, 01 Feb 2019 11:55:46 GMT

You could create Qlik Variable like:

Variable: ReportName

with definition

=Concat(Distinct YourFilteredField,'_')

and then use Qlik variable in dynamic report name syntax (see pictures below)

I have used QlikView, but Qlik Sense variables can be used in the same way. In the below example i filter report to show only Dim1 = A.

regards

Lech

Re: NPrinting Dynamic Report Naming Using Filter Value

baarathi — Tue, 05 Feb 2019 05:58:27 GMT

@Lech_Miszkiewicz Thank You. The qlik variable expression you gave does not seem to work. Remaining things works fine. For the qlik variable i have used getselectedfield(fieldname).

Re: NPrinting Dynamic Report Naming Using Filter Value

Steveo250k — Tue, 05 Nov 2019 17:28:12 GMT

I don't see how this is supposed to work. I have my filters in NPrinting, not Qlik Sense. How is creating a variable in Qlik Sense going to know the filter values I'm setting in NPrinting?

Re: NPrinting Dynamic Report Naming Using Filter Value

Lech_Miszkiewicz — Tue, 05 Nov 2019 22:58:18 GMT

Hi @Steveo250k,

Filters in NPrinitng apply selections in Qlik Sesnse data model. If you look close to the way how i suggest using variable you will notice that it starts with "=" sign, meaning that it evalueates every time there is a change in data model (change like applied selection etc.). So as soon as you apply NPrinitng filter it applies the field selection on Qlik Sense data model, variable gets evaluated, evaluated value gets returned back to NPrinting and can be used for whatever purpose you need it.

regards