Discussion Board for collaboration on QlikView Scripting.
I have the following piece of script:
LOAD Floor(SalesID) as SalesID, Name INLINE [
4, David R
ApplyMap('Emp', RandNum,'Missing') as SalesPerson,
Floor(Rand() * 5) as RandNum,
The output is blank for SalesPerson column:
Any idea how to fix this?
The point is to assign a random sales person based on the RandNum field.
Go to Solution.
Mapping key word missing
mapping LOAD Floor(SalesID) as SalesID, Name INLINE [
Did you miss the Mapping keyword?
Of course, such a silly mistake thank you
And maybe use
Floor(Rand() * 6) as RandNum,
so that Teresa gets a chance to get picked, too.