topic Re: How to export file txt with custom format in QlikView

How to export file txt with custom format

Anonymous — Mon, 14 Sep 2015 03:52:34 GMT

Hi everyone,

I wanna export my table chart to file txt on the server. The data will show the following format:

data a; data b ; data c; data d; data e.

data asub; data bsub; data csub; data dsub; data esub.

But it export file txt with wrong formart like this :

Can anyone help me to export to file txt with " ; " formar and it will Self-downloaded file txt , please ?

I have attached file to easy help me!

Thank in advance.

Re: How to export file txt with custom format

Gysbert_Wassenaar — Mon, 14 Sep 2015 05:38:16 GMT

Right click the table, choose the Export option from the context menu and select as Save as Type the option Semicolon delimited (*.skv, *.txt).

The Export action can only export to comma separated values. There are no options to change the delimiter. If you still want to export using a button you'll have to write macro code to do that.

Re: How to export file txt with custom format

qlikviewwizard — Mon, 14 Sep 2015 05:52:54 GMT

Hi,

Add the below syntax in script.

store mytable into myfile.CSV (txt);

Re: How to export file txt with custom format

Anonymous — Mon, 14 Sep 2015 08:22:54 GMT

hi qlikviewwizard‌,

Thank you.

I can export to file txt in Desktop. But I cant do this in the Server when I open qlikview file in web browser ( Qlik Access Point ).

Can you give me another solution,pleasse?

Re: How to export file txt with custom format

qlikviewwizard — Mon, 14 Sep 2015 08:26:38 GMT

Hi kirkleehuang

It is not possible to do this through Access point. Hope this will help you.

Re: How to export file txt with custom format

Anonymous — Mon, 14 Sep 2015 08:37:29 GMT

hi gwassenaar‌,

Thank you so much but I wanna export file to txt when I open file in the web browser ( Qlikview Access Point) .

I just have only 2 choices in the Qlikview Access Point.

Could you please help me other way ??

Re: How to export file txt with custom format

Anonymous — Mon, 14 Sep 2015 09:26:26 GMT

Hi qlikviewwizard‌,

ya, Qlikview Access Point support 2 ways to export file. Thank your answer

Re: How to export file txt with custom format

qlikviewwizard — Mon, 14 Sep 2015 09:29:36 GMT

‌hi lee please select correct and helpful answers, and close the thread.