Discussion Board for collaboration on QlikView Scripting.
Let's say I have the following table:
Order By OrderDate
Is it possible in the above to randomly swap the field to order by?
Say it's OrderDate but in the next reload it can randomly order by CustomerID or ProductID.
How is it possible to do this? Any ideas?
Go to Solution.
May be like this (Have not tested this, but I think it should work):
LET vRand = Ceil(Rand() * 3);
LET vField = Pick($(vRand), 'OrderDate', 'CustomerID' , 'ProductID');
Order By $(vField);