topic Re: Nprinting Dynamic Name with variables in QlikView

Nprinting Dynamic Name with variables

CVR — Wed, 25 Nov 2020 16:16:04 GMT

Dear Qlik Experts,

I want to give a dynamic name to on-demand word docx and I am using a QV variable to do that. The variable gives names based on the selection i,e if i select "APPLE" on a dashboard that exact word will reflect on the file name. I have an issue here, if i select "SWEET APPLE " I am getting the file name as SWEET+APPLE. I mean if there is a space between two words I am getting '+' symbol between two words. Is there anyway I can solve this?

Thanks in advance,

Arjun Reddy

Re: Nprinting Dynamic Name with variables

bhaskar_sm — Wed, 02 May 2018 20:01:17 GMT

Hi,

you can use use your variable name with in the doubleques with $ sign like : "$(vSelectedIteamName)".

if you found this helpful, please mark as helpful or correct.

Regards,

Bhasker Kumar

Re: Nprinting Dynamic Name with variables

tamilarasu — Thu, 03 May 2018 02:34:48 GMT

Hi Arjun,

I just tried to replicate it but for me it is naming the file name as "Sweet Apple". Can you show us how did you store the selections in that variable or what function did you use? Is it possible to attach snapshots for better understanding?

Re: Nprinting Dynamic Name with variables

CVR — Thu, 03 May 2018 16:18:46 GMT

Thanks for your reply but How can I use variable name like "$(vSelectedIteamName)". this in NPrinting dynamcic variable ? It is throwing an error

Re: Nprinting Dynamic Name with variables

Chanty4u — Thu, 03 May 2018 16:24:52 GMT

use variable like below

vFieldName

=Only(FieldName) and use vFieldName variable as dynamic in nprinting

Re: Nprinting Dynamic Name with variables

CVR — Thu, 03 May 2018 16:26:17 GMT

Thanks for your reply

If(GetPossibleCount(FruitName)=1, FruitName, 'Fruit') this is my variable vFruit. and In FruitName column there are many fields like Apple, Sweet Apple, Red Plum.

Re: Nprinting Dynamic Name with variables

tamilarasu — Thu, 03 May 2018 18:01:06 GMT

I am not sure but this is working fine for me. Create a new word document and paste the variable in your report and let us know what you see. If you see "Sweet Apple" then it should work in "Dynamic naming" as well.

Re: Nprinting Dynamic Name with variables

CVR — Thu, 03 May 2018 18:02:50 GMT

You are right but I am talking about Filename .i,e Sweet Apple.Docx

Re: Nprinting Dynamic Name with variables

tamilarasu — Thu, 03 May 2018 18:05:27 GMT

Actually, we are testing the variable value in above step .

Re: Nprinting Dynamic Name with variables

CVR — Thu, 03 May 2018 18:08:05 GMT

I want to use the same variable as the file name for the docx that is going to be generated after clicking the run report button on dashboard

Re: Nprinting Dynamic Name with variables

tamilarasu — Thu, 03 May 2018 18:13:59 GMT

Just follow my steps. First, you need to check what is the variable value. I just created sample file and tested for you. See below snapshots. It is working fine and I don't find any issue.

Re: Nprinting Dynamic Name with variables

CVR — Thu, 03 May 2018 18:16:45 GMT

Can you please share the QVW? I am getting Sweet+Apple everytime. Just want to check where I am going wrong?

Re: Nprinting Dynamic Name with variables

tamilarasu — Thu, 03 May 2018 18:20:36 GMT

Here you go.

Re: Nprinting Dynamic Name with variables

CVR — Thu, 03 May 2018 18:40:55 GMT

I am getting the same thing and I ran the report on access point, local and also preview but still I am having the same issue

Re: Nprinting Dynamic Name with variables

tamilarasu — Thu, 03 May 2018 18:53:07 GMT

That is strange. I have no idea. Same qvw file but getting different file names.

rpc Any idea? Thanks

Re: Nprinting Dynamic Name with variables

Ruggero_Piccoli — Fri, 04 May 2018 08:08:53 GMT

Hi,

Try to remove the "+" symbol.

Best,

Ruggero

Re: Nprinting Dynamic Name with variables

bhaskar_sm — Fri, 04 May 2018 08:55:17 GMT

Hi,

its happening due to spaces in the string and there for filename doesnt allow to have it that way + sybmol is appended by default. i will recommend to replace the space with some other charcter like "_" or no spaces.

replace(vFilename,' ','_') or eplace(vFilename,' ','')

Regards,

Bhasker

Re: Nprinting Dynamic Name with variables

CVR — Fri, 04 May 2018 13:55:37 GMT

I used replace and I am getting SWEET_APPLE at least this is acceptable but there are almost symbols like

(

)

for all these I am getting HTML Codes respectively which is anyway not confined to NPrinting only it is same for any URL over the web. Now I have to replace all these symbols in my data to _?

Re: Nprinting Dynamic Name with variables

Ruggero_Piccoli — Mon, 07 May 2018 07:44:45 GMT

In my opinion special characters should always be avoided. They often generate issues and many times in a non predictable point.

Best Regards,

Ruggero

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT https://community.qlik.com/docs/DOC-14806. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Nprinting Dynamic Name with variables

CVR — Mon, 07 May 2018 14:08:12 GMT

Hi Ruggero Piccoli, I am not using any special characters for file name. I am just taking the selected field from the dashboard and each field has different symbols.