Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

convert number string

Hi Community,

my data is: 00023456812

when I export the data into Excel the field value becomes 23456812


I used the function Text(00023456812) but it doesn't work.


Could you help me?


Fabio M

5 Replies
Highlighted
Creator III
Creator III

Hi Fabio,

you could add an preceding #-sign for example and cut it in excel afterwards. Could be a little inconvenient, but should work.

Regards

Chris

Highlighted
Master II
Master II

Hi Fabio,

This is a limitation with the excel export. Hopefully we will have a rectified update in the next version of Sense release.

Thanks,

Sangram Reddy.

Highlighted
Partner
Partner

Hi

ahi! ahi! ahi!


Could you give me a forecast output of release?

Highlighted

QlikView has a setting that controls the formatting that applies on export to Excel.

This article details how that setting is applied in QlikView.

Re: send to excel with Expression Default

It does not look like the setting applies to QlikSense or is available in QlikSense

Highlighted
Master II
Master II

Hi Fabio,

Wish I have built a Predictive model for it! I am expecting it to be fixed in the next release, which I think is in the coming month(Feb). Fingers crossed. Lets see!

Thanks,

Sangram.