Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sheetal2021
Contributor
Contributor

How to export straight table into .csv file in Qlikview

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

Labels (1)
1 Solution

Accepted Solutions
Jordi_Yherla
Support
Support

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-f...

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

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

View solution in original post

2 Replies
Jordi_Yherla
Support
Support

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-f...

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

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

sheetal2021
Contributor
Contributor
Author

Thanks Jordi😊 It's helpful...