Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
CVR
Creator
Creator

Nprinting Dynamic Name with variables

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

20 Replies
tamilarasu
Champion
Champion

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.

Capture.PNG

Capture.PNG

CVR
Creator
Creator
Author

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

tamilarasu
Champion
Champion

Here you go.

CVR
Creator
Creator
Author

Fruit.PNG

Fruit2.PNG

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

tamilarasu
Champion
Champion

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

rpc Any idea? Thanks

Ruggero_Piccoli
Support
Support

Hi,

Try to remove the "+" symbol.

Best,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
bhaskar_sm
Partner - Creator III
Partner - Creator III

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

CVR
Creator
Creator
Author

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 _?

Ruggero_Piccoli
Support
Support

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.



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
CVR
Creator
Creator
Author

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.