Discussion Board for collaboration on QlikView Scripting.
I am trying to set a variable:
SET JANRETENSION = B201;
(I tried it will as SET JANRETENSION = 'B201' as well and it didn't work either)
But when I use it in my where clause it is not recognized.
Here is the script followed by the error message:
Load[Dept] as [Temp Dept],sum([Commission]) as [Temp Commission Dept] Resident ProductionWhere ProdGLMonthOrig <= $(JANRETENSION)
ProdGLMonthOrig >= $(JANRETENSION)
Group By [Dept]Order by Dept ASC;
Error MESSAGE I am getting:
Field not found - <B201>
[Dept] as [Temp Dept],
sum([Commission]) as [Temp Commission Dept]
ProdGLMonthOrig <= B201
ProdGLMonthOrig >= B201
Group By [Dept]
Order by Dept ASC
Go to Solution.
You have to use it this with single quotes:
ProdGLMonthOrig <= '$(JANRETENSION)'
ProdGLMonthOrig >=' $(JANRETENSION)'