Hello everyone, I hope you can help me with the conversion to Qlik Language of this expression:
RND_ID = INTEGER(((FLOAT(ABS(Product_ID))/SQRT(FLOAT(ABS(Product_ID))))-INTEGER(FLOAT(ABS(Product_ID))/SQRT(FLOAT(ABS(Product_ID)))))*100000)
What I'm trying to do is create a list of Products numbers and assign each Product an equally distributed pseudo-random number between 0 and 100,000 based on the Product-ID
Product_ID = AA45YYY7H00001
I hope I´ve explained myself well
Thnak you
