Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Changing excel sheet data once loaded in qlik

Hi,

I want to change the excel sheet data which I have already uploaded in Qlik.The number of rows and columns are same I just wanted to replace existing variables with new variable so that the visualisation automatically changes .

10 Replies
karthikoffi27se
Contributor III

Re: Changing excel sheet data once loaded in qlik

Hi Ankit,

Can you share an example please.

You can use the define the variable and then call the variable in button and the dynamically change the data.

Many Thanks

Karthik

h_eskelinen
New Contributor III

Re: Changing excel sheet data once loaded in qlik

Hey Ankit,

It's not quite clear what you would like help with. Do you want to reload your dashboard with new data from an updated excel file? Or do you need help in modifying an expression for a chart? Please provide more details and, if possible, include a screenshot of what you would like to change. Thanks!

kumarkp412
Contributor II

Re: Changing excel sheet data once loaded in qlik

Hi Ankit,

Can you elaborate your question. It was something confusion .

Thanks

Not applicable

Re: Changing excel sheet data once loaded in qlik

Hi All,

I just want to replace the older excel sheet data with new updated excel sheet.The number of rows and columns everything is same in the older and new data. However few values are getting updated and I want the dashboard to automatically update accordingly .

All,I am concerned about is after uploading the new data will the charts and graph change accordingly to the new data.I want the charts and graph to change as I upload the new data.

Thanks,

Ankit

Not applicable

Re: Changing excel sheet data once loaded in qlik

Hi ,

I want to reload your dashboard with new data from an updated excel file.

Not applicable

Re: Changing excel sheet data once loaded in qlik

Hi,

I deleted the older data and added the new data in the sheet and I get this error that data not loaded because error in scripts please correct script in data load editor and update the data.

I am not sure why this is coming

danansell42
Contributor III

Re: Changing excel sheet data once loaded in qlik

As long as the field (column) names haven't changed your charts should update to reflect the new data once dashboard has been reloaded

Not applicable

Re: Changing excel sheet data once loaded in qlik

Hi,

I deleted the older data and added the new data in the sheet and I get this error that data not loaded because error in scripts please correct script in data load editor and update the data.

I am not sure why this is coming .I am not sure if i am uploading the data correctly

danansell42
Contributor III

Re: Changing excel sheet data once loaded in qlik

can you share the script?

Could be anything