Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

saadzaman
New Contributor III

Store Qvd as CSV with special characters

Hi All,

How can I Store QVD as .CSV or .XLSX.

Please assist.

Regards,

Saad

5 Replies
oknotsen
Honored Contributor III

Re: Store Qvd as CSV with special characters

For details on STORE, see here:

Store ‒ Qlik Sense

Use this example to store as CSV (as that effectively is a txt):

store mytable into myfile.txt (txt);

May you live in interesting times!
saadzaman
New Contributor III

Re: Store Qvd as CSV with special characters

HI Onno,

This gives me missing data in between.

Regards,

Saad

Re: Store Qvd as CSV with special characters

For CSV file storing do this

Store Table1 into TableName.csv(txt)

oknotsen
Honored Contributor III

Re: Store Qvd as CSV with special characters

You will have to be more specific about what your problem is.

May you live in interesting times!
Lech_Miszkiewicz
Honored Contributor III

Re: Store Qvd as CSV with special characters

Hi Saad,

You cannot directly store QVD to CSV. You can however store loaded table to txt or csv files
You can store table in script only to text delimitted (not xlsx) files like csv or txt with defined delimiter.

Examples:

  1. STORE YourTable into YourTable .txt (txt, delimiter is ';' );
  2. STORE YourTable into YourTable .csv (txt, delimiter is ',' );

read more about delimiter here:

https://help.qlik.com/en-US/sense/November2017/Subsystems/Hub/Content/Scripting/ScriptSpecifiers/del...

You are not able to store table to XLSX (in Script or automaticly) - you can only do this from the UI or use NPrinting Tool to create more advanced XLS exports.

cheers

Lech

---------------------------------------------

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

cheers Lech
When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution.
Please LIKE threads if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem.
Community Browser