Can On-Demand report names be dynamic?

[mwallman]

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?

[Daniel_Jenkins · Accepted solution]

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.

[Chanty4u]

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]

Don't forget the = in the variable value.

[Chanty4u]

thanks let me try and update you

[Chanty4u]

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]

HI Does this also work for Nprinting September 2020?