topic Re: Qlik Sense Export a table (.qvd) as it is to CSV by Click on Button (no reply from Qlik Community) in Integration, Extension & APIs

Qlik Sense Export a table (.qvd) as it is to CSV by Click on Button (no reply from Qlik Community)

Thu, 19 Jan 2017 01:17:51 GMT

Hi,

I have a table like this ( A QVD file). I want to see this as it is on CSV.

Date Status Bank count

01-05-2017 Active Amex 130

01-05-2017 In-Active Amex 334

01-05-2017 Active Chase 5345

01-05-2017 Active BOA 45

01-05-2017 In-Active Wells 342

01-05-2017 Active Citi 730

01-05-2017 In-Active BOA 320

01-05-2017 In-Active Citi 30

01-06-2017 Active Amex 3430

01-06-2017 In-Active Amex 50

01-06-2017 Active Chase 330

01-06-2017 Active BOA 36

01-06-2017 In-Active Wells 32

01-05-2017 Active Citi 31

I want to export this table as it is in CSV on a button click from dashboard. Is there any way that I can click a button or link on my dashboard, so that the table (QVD file) will download as CSV File on my computer from browser.

I tried creating Pivot table, normal table on dashboard ans exported but the data automatically doing aggregation by date as

Date Status Bank count

01-05-2017 - - 6130 (It is taking aggregate number and giving one record per day)

01-06-2017 - - 4130

It is not giving all records for that date. It is giving one record per day that is aggregated data.

Simple requirement, I want to download my QVD table to CSV from Dashboard. I need whole raw data, not the data I plotted on Dashboard.

Can any one help with this? Thank you.

Re: Qlik Sense Export a table (.qvd) as it is to CSV by Click on Button (no reply from Qlik Community)

Digvijay_Singh — Thu, 19 Jan 2017 21:44:23 GMT

I think you should use store statement in the script to store raw data in the csv format.

From UI the data get exported in excel format but it would take a long if data size is huge.

Check this link in case the indicated extension may help to export in csv from UI.

Re: Sense CSV Export

Re: Qlik Sense Export a table (.qvd) as it is to CSV by Click on Button (no reply from Qlik Community)

Digvijay_Singh — Thu, 19 Jan 2017 21:48:30 GMT

I tried to make table out of your data and then exported using right click/export, I got it in excel as it is appearing in table, not sure why it is aggregating for you

Re: Qlik Sense Export a table (.qvd) as it is to CSV by Click on Button (no reply from Qlik Community)

Thu, 19 Jan 2017 23:05:21 GMT

Hi Thanks for the reply. It worked for me also.

We need to expand pivots it worked. Is there any way I can keep a button and do the same stuff.

Like 'Export Table', underneath it runs the load/store script what ever and downloads file?

This is my primary query. Using a button.

But anyway thanks though! Your reply helped me.

Re: Qlik Sense Export a table (.qvd) as it is to CSV by Click on Button (no reply from Qlik Communit

Manolis — Thu, 13 Dec 2018 15:34:02 GMT

Hi Guys I have a requirement from a customer to export some table with the following rules

- must be a csv file

- comma as the delimiter

- text fields enclosed in double quotes

- numeric fields without any quotes, and using . as decimal separator

No problem with the first two, but how can I enforce the double quoting? Qlik just encloses automatically the string values that include a comma... For the numeric format, could you help me with the Num function needed? I need the value with two decimals separated by a dot. Thanks and regards Javier