Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Nir
Contributor II
Contributor II

change table cell from sheet

Hi

Is there a way to change  cell(field) in the excel from the sheet? 

example: 

i am getting from the excel customer name but i want from the sheet add application for each customer (if needed).

i can add excel file with customer name and application but since i am getting new customers everyday the appication should be something i can add from the sheet - how to do that ? 

thx

Nir

 

Labels (1)
1 Solution

Accepted Solutions
Andrea_Bertazzo
Support
Support

Hi @Nir 

 

If I understand correctly, you need to add a value (application) to some of the customers you import every day from Excel. You would like to do this directly in the Qlik Sense table.

I don't think this is possible. It is much better that the modification is done in the Excel file and that you then run a reload to import the new data in Qlik Sense from Excel.

You may schedule some recurring reloads to do this.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂

View solution in original post

1 Reply
Andrea_Bertazzo
Support
Support

Hi @Nir 

 

If I understand correctly, you need to add a value (application) to some of the customers you import every day from Excel. You would like to do this directly in the Qlik Sense table.

I don't think this is possible. It is much better that the modification is done in the Excel file and that you then run a reload to import the new data in Qlik Sense from Excel.

You may schedule some recurring reloads to do this.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up ! 🙂