Qlik Community

Ask a Question

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
May 18th, Changes to the way you login: using email vs. username. READ DETAILS/WATCH VIDEO
cancel
Showing results for 
Search instead for 
Did you mean: 
mwallman
Creator III
Creator III

Can On-Demand report names be dynamic?

Hello,

With my pharmaceutical company there is a requirement where they want to make OnDemand reports with QlikView names to be dynamic.

E.g. You might have a report called Sales Analysis.

What we want to do is if user makes selection on Country, and run a On-Demand report then we want the report name to be include the selected country.

E.g. Sales Analysis Argentina.

Is dynamic naming possible with QlikVIew On-Demand reports?

1 Solution

Accepted Solutions
Daniel_Jenkins
Support
Support

Hi Michael,

Yes it is. You can achieve this using a QlikView variable and NPrinting Dynamic naming.

Example:

* QVW has a Field called Region Market

* Create a Variable: vRegion with value =Only([Region Market])

* Create your NPrinting report as you normally would but also check Enable dynamic naming and build the Dynamic name to include the Qlik variable vRegion

* When the on-demand report is created:

① Without any selections or with multiple selections - no Region is appended to the filename

② With a single selection - Region is appended to the filename

I suggest you also try with variable value =GetFieldSelections([Region Market]) for multiple Region selections

HTH - Daniel.

View solution in original post

6 Replies
Daniel_Jenkins
Support
Support

Hi Michael,

Yes it is. You can achieve this using a QlikView variable and NPrinting Dynamic naming.

Example:

* QVW has a Field called Region Market

* Create a Variable: vRegion with value =Only([Region Market])

* Create your NPrinting report as you normally would but also check Enable dynamic naming and build the Dynamic name to include the Qlik variable vRegion

* When the on-demand report is created:

① Without any selections or with multiple selections - no Region is appended to the filename

② With a single selection - Region is appended to the filename

I suggest you also try with variable value =GetFieldSelections([Region Market]) for multiple Region selections

HTH - Daniel.

View solution in original post

Chanty4u
Champion III
Champion III

thanks Daniel Jenkins but  only will work if there is no null right?

for me i am getting the result with  filename_only(fieldname)

how to overcome this?

Daniel_Jenkins
Support
Support

Don't forget the = in the variable value.

Chanty4u
Champion III
Champion III

thanks let me try and update you

Chanty4u
Champion III
Champion III

Nice Daniel it works perfect .

lech suggested someway (may be i done wrongly) but i didnt get it.  these many days almost 80 reports manually changed the report name

you saved me thanks again.

Label name Dynamic

Senor_Dai
Partner
Partner

HI Does this also work for Nprinting September 2020?