How to export straight table into .csv file in Qlikview

sheetal2021 — Sat, 23 Jul 2022 11:20:59 GMT

Hello Team,

I want to export straight table into .csv file after data refresh. But I don't have NPrinting and not allowed to use Macro.

Kindly help..

Thanks,

Sheetal

Re: How to export straight table into .csv file in Qlikview

Jordi_Yherla — Mon, 25 Jul 2022 09:34:56 GMT

Hello,

Searching in Qlik Community, you will notice that most of the suggested answers require the use of Macro or NPrinting, which is not what you are looking for. Some of these suggestions can be found in:

"How do Straight table data can export to csv or xls file automatically. ?" > 2018-04-27 01:56 PM CEST [1]
"How do Straight table data can export to csv or xls file automatically. ?" >‎ 2018-08-27 05:46 PM CEST [1]

You can submit a feature request [2], to have this option available by default.

The only workaround that might help you achieve your use case scenario is the use of "STORE" command in the load script. For further information, you can check [1] (‎2018-04-27 01:56 PM CEST) and "Need To Export Straight Table To Excel Automatically On Reload" [3].

For example, I have the following script:

You can use functions to create calculated dimensions (Similar table to the straight one that you have) and then export it as a CSV file. This will be done every time the data is reloaded as you need.

[1] https://community.qlik.com/t5/QlikView-App-Dev/How-do-Straight-table-data-can-export-to-csv-or-xls-file/m-p/27780

[2] https://community.qlik.com/t5/Knowledge/How-To-Submit-Feature-Requests-For-Qlik-Products/ta-p/1712581

[3] https://community.qlik.com/t5/QlikView-App-Dev/Need-To-Export-Straight-Table-To-Excel-Automatically-On-Reload/td-p/59982

Re: How to export straight table into .csv file in Qlikview

sheetal2021 — Mon, 25 Jul 2022 10:03:10 GMT

Thanks Jordi😊 It's helpful...

topic Re: How to export straight table into .csv file in Qlikview in App Development

How to export straight table into .csv file in Qlikview

Re: How to export straight table into .csv file in Qlikview

Re: How to export straight table into .csv file in Qlikview