Discussion board where members can get started with QlikView.
I was trying to follow some other post of how to generate a random value to check but I can´t get the variable to work. Can some of you se what I´m doing wrong?
LET RandomRow = round(Rand()*(NoOfRows(KKIK_Key)));
peek('KKIK_Key',$('RandomRow'),'KKIK') as KKIK_Key,
peek('KKIK_Key',$('RandomRow'),'KKIK') as KKIK_Random_ID
//peek('KKIK_Key','1','KKIK') as KKIK_RandomCheck_ID <---- This works, gives me a id to check on
Go to Solution.
Have you tried
peek('KKIK_Key',$(RandomRow),'KKIK') as KKIK_Key,
and check also the variable created, I think I would use something like
LET RandomRow = floor(Rand()*(NoOfRows('KKIK_Key')));
My fault with round(), thanx.
Hi. Sorry for late replay but was gone for the weekend. Thanks for the help!