topic Re: Create unique ID's in QlikView

Create unique ID's

annanirvin — Wed, 24 Apr 2019 13:18:32 GMT

Hi.

I have data as below. I would like to create 73 unique ID with date 2019-04-22, 56 unique ID with date 2019-04-23 etc. The ID for 2019-04-22 must not be the same as for 2019-04-23. How do I do this, please?

Date	Qty
2019-04-22	73
2019-04-23	56
2019-04-24	64

Thanks 🙂

Re: Create unique ID's

sunny_talwar — Wed, 24 Apr 2019 13:29:17 GMT

Try this

Table:
LOAD Date,
	 Qty,
	 Hash128(Date&IterNo()) as ID
While IterNo() <= Qty;
LOAD * INLINE [
    Date, Qty
    2019-04-22, 73
    2019-04-23, 56
    2019-04-24, 64
];

Re: Create unique ID's

annanirvin — Wed, 24 Apr 2019 16:25:37 GMT

Hi.

Thanks for your reply. I don't seem to make your suggestion work, I get this very strange IDs. I also forget to tell that I want the quantity to be 1 for each ID, is that possible?

ID	Qty
MOTH&P=2[:MLHK:PO=>/;&	73
MEP54NG.R:M,%=O2*Z,<;&	73
M3'<ZNY/U:ML[AH<!&H";&	73
M)#)(M#,L:M,,Z%.5!P";&	73

Re: Create unique ID's

sunny_talwar — Wed, 24 Apr 2019 16:39:24 GMT

Do you want to make an ID which makes sense? May be try this

Table:
LOAD Date,
	 Qty,
	 Num(Date)*100000+IterNo() as ID
While IterNo() <= Qty;
LOAD * INLINE [
    Date, Qty
    2019-04-22, 73
    2019-04-23, 56
    2019-04-24, 64
];

For the second question, I am seeing 1 when I use Count(DISTINCT ID) with ID as the dimension

Re: Create unique ID's

sunny_talwar — Wed, 24 Apr 2019 16:40:42 GMT

Oh I see, you want the Qty as 1 from the script... do this

Table:
LOAD Date,
	 1 as Qty,
	 Num(Date)*100000+IterNo() as ID
While IterNo() <= Qty;
LOAD * INLINE [
    Date, Qty
    2019-04-22, 73
    2019-04-23, 56
    2019-04-24, 64
];

Hard code the value to be 1, since it will always be 1 and nothing else

Re: Create unique ID's

annanirvin — Wed, 24 Apr 2019 17:00:59 GMT

This is perfect! Thank you very much.