I am using a stored procedure to populate the QVD, and for incremental load I donot have any primary key in my data set. In my data set I have a column Flag, if Flag is 0 its new and 1 is Old. How can I implement this in my Qlik View Report so that Only those records come in the report with Flag 0. If the dataset records were updated to FLag = 1 then that record should not come in report.
Did Michael's post get you what you needed for your use case? If so, please do not forget to return to your post and use the Accept as Solution button on his post to give him credit for the assistance and let other Community Members know that worked for you.
The only other thing I have is the following, not sure it will be of much help, but figured I would put it out here for others too:
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
you have no way at least create a key concatenating fields ??? beyond having the flag, I would think of having a date at least to only bring the news, with the theme of the flag, if you know how old, you leave it in the QVD, I imagine that you are going to bring only those that the flag has in 0, this in the first instance would not be bad, but, the problem comes in that you can get to have a flag at 0 and add it to the model, and continue having it the next reload, so you would have repeated.