How do Straight table data can export to csv or xls file automatically. ?

[tulabandula]

Hi All,

I am looking out for a solution to export the straight table data into .csv or .xls file everyday automatically in a folder given. Can anybody help me with code to export the chart data into desired file and folder with full of data(6 lak records).

Thanks in Advance...!

[CarmenReilly]

Hi Sreeni!

Is this QlikView or Qlik Sense?

-Carmen

[eduardo_dimperio]

QLIK SENSE

Store YourTable INTO [Your_Path.csv](txt)

This will export to CSV, Qlik Sense does not export automatically (yet) to xls

[tulabandula]

Hi Carmen,

Thank you for your reply..

I am wondering in qlikview as of now.

thanking you.

Sreeni

[tulabandula]

Hi Carmen,

requirement is in Qlikview.

Thanks in advance.

-Sreeni

[adityaakshaya]

Hi Sreeni,

There are two ways through which you can achieve this.

1. Using NPrinting, You can schedule your straight table export

2. Using the load script. Create a table same as Straight table(having the same dimensions and measures) in the script and you can store the table as below

Store <Your Table Name> into <YourFileName.csv>(txt)(delimiter is ','); Now whenever your application get refresh it will create a csv and save it to your desired location.

Hope this helps.

Regards

[Anonymous]

Hi Sreeni,

I've moved this post to the New to QlikView space for you, as it will get the most relevant responses there.

Best regards,

Qlik Community Team

[tulabandula]

Hi Aditya,

Thank you for giving couple of options but tedious for small accounts..

Need to download 10 reports so i would have resident 10 times with respective field to store specific report dimensions for Storing in to .CSV hence can i have a macro script type of solution where Chart Object(CH01) can download and send over an email to user Without installing N Printing..

Regards,

Sreeni.

[adityaakshaya]

Hi Sreeni,

Sorry for replying late.

Yes you can use Macro for exporting but macro will not work on Qlik server and also not suggested by Qlik.

Regards,

Akshaya

[tulabandula]

Thank you Akshaya Aditya.