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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sabari1910
Contributor III
Contributor III
‎2021-05-18 05:31 AM

Qlikview inputbox doublespaing issue when pasting the data from Excel sheet

Hi All,

We are facing the issue when copying the multiple row values from Excel and pasting them into Qlikview Inputbox field.

The values are getting automatically updated with double space instead of break character.

Someone already raised the same issue(see below url) in Community ,but no solution given.

https://community.qlik.com/t5/QlikView-App-Dev/Multiple-values-pasting-from-excel-to-Input-box-issue...

Need urgent help on this.

604 Views
0 Likes
2 Replies
sabari1910
Contributor III
Contributor III
‎2021-05-18 10:48 AM
Author

Qlik experts--Any suggestions pls

564 Views
marcus_sommer
MVP
MVP
‎2021-05-19 08:44 AM

I think you couldn't change the behaviour (which is AFAIK caused from Excel which put line-breaks between the rows which aren't accepted on the QlikView side and replaced by a space) else you need a different approach either in the way you transfers the data into QlikView or how they are processed there.

This means you could create an appropriate string within Excel which is quite simple and fast or you change the variables/expressions which calculate with the input-value maybe just with a replace().

- Marcus 

543 Views