topic Re: Database to excel in QlikView

Database to excel

Thu, 30 Oct 2014 08:55:43 GMT

Hi All,

I have connected Qlikview app to database and have also loaded the data.

Now i want to load that data into excel sheet.

Let me know the script syntax.

Thanks

anbu1984 — Thu, 30 Oct 2014 08:58:37 GMT

Check this link

vardhancse — Thu, 30 Oct 2014 09:15:24 GMT

If we want to export data to excel, why cant' u directly export from DB.

If want to export data from QlikView we can use some objects in front end and can export the data to excel.

Straight table,Table Box -> Export to excel.

If not in script->

Store into (File_Name.xlsx);

its_anandrjs — Thu, 30 Oct 2014 09:47:19 GMT

Hi,

From Qlikview table not store file as the Excel file you have to store it CSV text and then you can save it later as excel file from windows

Ex:-

TableName:

LOAD * Inline

[

Regions,Sales

R1,4582

R2,2563

R3,2693

R4,1852

];

STORE TableName into TableName.csv(txt);

Regards

Anand

ashfaq_haseeb — Thu, 30 Oct 2014 10:07:52 GMT

Hi,

Try like this

STORE [Your Table Name] into [Your Table Name].xls(txt);

Regards

ASHFAQ