Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check this link
http://www.quickintelligence.co.uk/write-csv-qlikview-store/
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);
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
Hi,
Try like this
STORE [Your Table Name] into [Your Table Name].xls(txt);
Regards
ASHFAQ