topic Re: Repeat Characters in Field in QlikView

Repeat Characters in Field

madhubabum — Wed, 30 Sep 2015 10:22:28 GMT

Hi experts

I am Having Code as field , I am added logic to field (To repeat the char )

When , i am stored the field values into Excel then i am not getting the repeated char .

How we can achieve this one ?

I am attaching the Excel file , Application , Excel output

Thanks

Madhu

avinashelite — Wed, 30 Sep 2015 10:29:48 GMT

That's the default nature in excel , try like this

Text((repeat('0',9-len([Code])))&[Code]) as

in the script level you will get the desired output

avinashelite — Wed, 30 Sep 2015 10:30:45 GMT

Code_Desc:

LOAD

Text((repeat('0',9-len([Code])))&[Code]) as [Code]

FROM

Book2.xlsx

(ooxml, embedded labels, table is Sheet1);

store [Code_Desc] into Code.xls(txt);

SreeniJD — Wed, 30 Sep 2015 10:31:30 GMT

Its exporting correctly for me in excel with the same qvw application. Are you using old version of Excel?

Sreeni

tresB — Wed, 30 Sep 2015 10:38:46 GMT

Help- >About QlikView, and then

Once this is set, try exporting then.