topic Qlikview inputbox doublespaing issue when pasting the data from Excel sheet in App Development

Qlikview inputbox doublespaing issue when pasting the data from Excel sheet

sabari1910 — Tue, 18 May 2021 09:43:23 GMT

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/m-p/1307394

Need urgent help on this.

Re: Qlikview inputbox doublespaing issue when pasting the data from Excel sheet

sabari1910 — Tue, 18 May 2021 14:48:34 GMT

Qlik experts--Any suggestions pls

Re: Qlikview inputbox doublespaing issue when pasting the data from Excel sheet

marcus_sommer — Wed, 19 May 2021 12:44:33 GMT

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