Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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.
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?
Don't forget the = in the variable value.
thanks let me try and update you
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.
HI Does this also work for Nprinting September 2020?