topic Using AutoNumber to replace fields? in QlikView https://community.qlik.com/t5/QlikView/Using-AutoNumber-to-replace-fields/m-p/516691#M557227 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>in a QlikView-App I have built, I had to implement a SELECT on the personell database just to determine, whether on any given Saturday, the company was producing or not. To that end, I count(distinct) the personell_numbers that checked in on that day, restricted to the core team of employees.</P><P>For that particular app, I don't even need to see the field with the personell number, I only need them as a unique identifier that I can count.</P><P></P><P>Can I, for further security, use the AutoNumber function in QlikView to replace the personell numbers by a unique numeric value? Then I would not even have to load it into my QliklView app.</P><P></P><P>The AutoNumber function does assign a unique number to any new value found in a field, doesn't it? Which one should I use? The simple one, the Hash128-variation or the Hash256-.variation? What is the difference anyway?</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Thu, 27 Jun 2013 11:57:20 GMT datanibbler 2013-06-27T11:57:20Z Using AutoNumber to replace fields? https://community.qlik.com/t5/QlikView/Using-AutoNumber-to-replace-fields/m-p/516691#M557227 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>in a QlikView-App I have built, I had to implement a SELECT on the personell database just to determine, whether on any given Saturday, the company was producing or not. To that end, I count(distinct) the personell_numbers that checked in on that day, restricted to the core team of employees.</P><P>For that particular app, I don't even need to see the field with the personell number, I only need them as a unique identifier that I can count.</P><P></P><P>Can I, for further security, use the AutoNumber function in QlikView to replace the personell numbers by a unique numeric value? Then I would not even have to load it into my QliklView app.</P><P></P><P>The AutoNumber function does assign a unique number to any new value found in a field, doesn't it? Which one should I use? The simple one, the Hash128-variation or the Hash256-.variation? What is the difference anyway?</P><P></P><P>Thanks a lot!</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Thu, 27 Jun 2013 11:57:20 GMT https://community.qlik.com/t5/QlikView/Using-AutoNumber-to-replace-fields/m-p/516691#M557227 datanibbler 2013-06-27T11:57:20Z