Discussion Board for collaboration related to QlikView App Development.
I need to count how many space characters are at the beginning of every row, but qv automatically deletes them.
How can I do it?
Thanks for your answer.
You need to set the Verbatim variable to 1 to prevent Qlikview from stripping the spaces. In the script you can add this line to prevent the trimming:
set Verbatim = 1;
View solution in original post
Hi, you can use this function
substringcount(yourField, ' ')
I doesn't work, it returns 0. QV automatically deletes the spaces from the beginning of the load and i need to not do this.
Any other solution?