topic Re: with out date and primary keys how to do incremental logic in QlikView https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73098#M768810 <HTML><HEAD></HEAD><BODY><P>ok,</P><P></P><P>use Autonumber('with fields you want')</P><P></P><P>ex :Autonumber(IdProduct &amp; CustomerID &amp; ......)</P></BODY></HTML> Fri, 29 Jun 2018 09:00:12 GMT ogautier62 2018-06-29T09:00:12Z with out date and primary keys how to do incremental logic https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73094#M768806 <HTML><HEAD></HEAD><BODY><P>If data has no date key and primary key how to do incremental logic.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73094#M768806 Anonymous 2020-11-25T16:16:04Z Re: with out date and primary keys how to do incremental logic https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73095#M768807 <HTML><HEAD></HEAD><BODY><P>How does your data look like?</P></BODY></HTML> Mon, 25 Jun 2018 12:34:08 GMT https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73095#M768807 sunny_talwar 2018-06-25T12:34:08Z Re: with out date and primary keys how to do incremental logic https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73096#M768808 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you ought to have necessarily a functionnal key to calculate increment,</P><P></P><P>ie what are the fields which identify your row as could do a primary key ?</P><P></P><P>regards</P></BODY></HTML> Mon, 25 Jun 2018 13:20:52 GMT https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73096#M768808 ogautier62 2018-06-25T13:20:52Z Re: with out date and primary keys how to do incremental logic https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73097#M768809 <HTML><HEAD></HEAD><BODY><P>Here data is like historical data we didn't have primary key</P><P>I think hash128() will works but i need exact logic and simple logic</P></BODY></HTML> Thu, 28 Jun 2018 12:21:30 GMT https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73097#M768809 Anonymous 2018-06-28T12:21:30Z Re: with out date and primary keys how to do incremental logic https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73098#M768810 <HTML><HEAD></HEAD><BODY><P>ok,</P><P></P><P>use Autonumber('with fields you want')</P><P></P><P>ex :Autonumber(IdProduct &amp; CustomerID &amp; ......)</P></BODY></HTML> Fri, 29 Jun 2018 09:00:12 GMT https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73098#M768810 ogautier62 2018-06-29T09:00:12Z Re: with out date and primary keys how to do incremental logic https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73099#M768811 <HTML><HEAD></HEAD><BODY><P>Hi Gautier </P><P></P><P>Thanks for reply i tried but using peek with hash128() i got the result.</P><P></P><P>Thank you</P></BODY></HTML> Wed, 04 Jul 2018 09:07:47 GMT https://community.qlik.com/t5/QlikView/with-out-date-and-primary-keys-how-to-do-incremental-logic/m-p/73099#M768811 Anonymous 2018-07-04T09:07:47Z