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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

with out date and primary keys how to do incremental logic

If data has no date key and primary key how to do incremental logic.

5 Replies
sunny_talwar

How does your data look like?

ogautier62
Specialist II
Specialist II

Hi,

you ought to have necessarily a functionnal key to calculate increment,

ie what are the fields which identify your row as could do a primary key ?

regards

Anonymous
Not applicable
Author

Here data is like historical data we didn't have primary key

I think hash128() will works but i need exact logic and simple logic

ogautier62
Specialist II
Specialist II

ok,

use Autonumber('with fields you want')

ex :Autonumber(IdProduct & CustomerID & ......)

Anonymous
Not applicable
Author

Hi Gautier

Thanks for reply i tried but using peek with hash128() i got the result.

Thank you