Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
taylor_jesse
Creator
Creator

Variable For Incremental Load

Hi,

I am currently working on modifying an existing dashboard that a previous developer created. currently the incremental load pulls data when the date updated is greater than the date the record was submitted but the variable for the date the record was submitted is hard coded so each time the load happens, the data is being overwritten which causes some locations in the data to have the new location instead of just adding to the existing record on the chart. Any suggestions on how to set the variable for last date submitted that way it does not overwrite the existing data in the chart?  So for instance if an individual was working in Dallas last month and is now back to their home team in Houston this month, the chart should show both records with the corresponding dates but at the month when the individual moves to Houston which is their home team, the chart overwrites the Dallas location and links the date the individaul was in dallas to the houston location.

Thank you

2 Replies
vishsaggi
Champion III
Champion III

It might not be hardcoded. There must be some code where this variable is set in your script. Check the whole script and look for this variable. However, based on your query you might need slowly changing dimensions. Or in the incremental load just do the Insert to get the duplicate values for your scenario. Few help files below:

Slowly Changing Dimensions

Building a slowly changing dimension in Qlikview

Anonymous
Not applicable

We've a situation where A) the existing source takes too long to load into a QVD and B) that source is cleared of anything over 3 years old (but they want to see it in QV)

We added a timestamp field to our source data, which is also pulled into the QVD, showing the date/time of update.

Prior to the load from the source, we interrogate the existing QVD for the newest timestamp and save it in a variable.

Then we load only what is later than that date.