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

[#1]

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.

[Digvijay_Singh]

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

[Digvijay_Singh]

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

[#4]

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.

[Manolis]

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