Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

dradoikov
New Contributor II

Change data and then save into excel

Hi,

I need help for this problem.

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

Thanks,

Daniel

1 Solution

Accepted Solutions

Re: Change data and then save into excel

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


talk is cheap, supply exceeds demand
7 Replies
vivientexier
Contributor II

Re: Change data and then save into excel

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
New Contributor II

Re: Change data and then save into excel

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
Honored Contributor II

Re: Change data and then save into excel

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

Table_Box.png

dradoikov
New Contributor II

Re: Change data and then save into excel

Hi Alan,

Can i change the data in table box?

Daniel

Re: Change data and then save into excel

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


talk is cheap, supply exceeds demand
rustyfishbones
Honored Contributor II

Re: Change data and then save into excel

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
New Contributor II

Re: Change data and then save into excel

Runs great!

Thank you very much

Community Browser