Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kellymcgrady
Contributor

Insert and Update

So im using insert and update and I have a file that is presenting some problems. the hash im using does not seem to be working and is staying identical even though I am changing cell values. I cant figure out whats causing this except for that it doesn't like all zero value but it is working on another table that had all zero values.

Tags (2)
6 Replies
MVP
MVP

Re: Insert and Update

Would you be able to share a sample where we can see the issue? One thing to check would be to look out for nulls may be... but other than that, I would have assumed the hash to have changed the values

kellymcgrady
Contributor

Re: Insert and Update

Would the original values all being zero make a difference ?

MVP
MVP

Re: Insert and Update

I would think not, but not 100% sure

kellymcgrady
Contributor

Re: Insert and Update

I tried rewriting the whole thing and it didn't work. Unfortunately I cant share a sample.

MVP
MVP

Re: Insert and Update

Okay

kellymcgrady
Contributor

Re: Insert and Update

I finally had to add in rowno() into the hash to get it to work. The rowno() is not in the corresponding hash to update it, not perfect but workable