Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

mwallman
Contributor

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

Re: Can On-Demand report names be dynamic?

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.

5 Replies
Employee
Employee

Re: Can On-Demand report names be dynamic?

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.

sureshqv
Esteemed Contributor III

Re: Can On-Demand report names be dynamic?

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?

Employee
Employee

Re: Can On-Demand report names be dynamic?

Don't forget the = in the variable value.

sureshqv
Esteemed Contributor III

Re: Can On-Demand report names be dynamic?

thanks let me try and update you

sureshqv
Esteemed Contributor III

Re: Can On-Demand report names be dynamic?

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

Community Browser