Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rasmuskolding
Contributor
Contributor

Blank spaces when peek

Hi all!

I have a table loaded from an excelfile with some text columns, in which som cells have blank spaces before or after the cell text. This is deliberate and needed for further use. However, in the debugger, I can se that blank spaces are removed from the variable when using peek() to retrieve values from the cell.

I am not sure if this is done by the peek function or upon load, but in either case, is there a way to retain the blank spaces in the cells?

Regards

Rasmus

2 Replies
el_aprendiz111
Specialist
Specialist

Hi

SET verbatim =1;

Table:

Load * from xyz.xlsx;

pradosh_thakur
Master II
Master II

Hi

refer this for the explanation.

http://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/SystemVariables/Verbati...

regards

Pradosh

Learning never stops.