Change data and then save into excel

[dradoikov]

Hi,

I need help for this problem.

I want change data in QlikView UI and then save into Excel file.

Thanks,

Daniel

[vivientexier]

You mean export data from the script or from one graph ?

From the script you can use the STORE instruction after your table creation :

• STORE mytable into myfile.txt (txt); // No excel format available.

From one graph

• Right click on your graph, chose "export" then a box offer you the possibility to save under Excel format.

[dradoikov]

Hi Vivien,

Thanks for quik answer.

This is the case.

in QlikView is imported Excel file.

In Excel there one column that I want to change in QlikView through the interface. After the change of the information in this column changes need to be saved again Excel file.

Thanks in advance,

Daniel

[rustyfishbones]

You can take the Excel file into Qlikview

Create a Table box will (Select all Columns) after you have made the Changes and then Export the Table Box Data to Excel and Save the Excel file

[dradoikov]

Hi Alan,

Can i change the data in table box?

Daniel

[Gysbert_Wassenaar · Accepted solution]

Only if you defined the field as an Input Field in the load script with the Inputfield statement. See the help file for details.

[rustyfishbones]

Listen to Gysbert, he is far more knowledgeable about these things, so I would trust what he is saying

You could make changes in the Script like adding, Month, Year, etc

And then add those new fields to the Table Box and then Export

[dradoikov]

Runs great!

Thank you very much