Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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.
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