How to filter a field using a variable as the value
We've recently installed Nprinting Sept 2020 on our servers and we are looking to update our existing Nprint jobs built on v16. We used to be able to filter a field using a variable from the Qlik app as the value. No matter what i try, I can't get this to work. Could someone provide me with an example so I can see the syntax used please?
This subject is not simple as variables can behave differently depending on how they are defined in QlikView. Is your variable static value or expression? If it is expression do you expand variable by using "=" sign in QlikView or do you just pass variable expression to NPrinting?
Now we would need to know whole scenario happening in NPrinitng 16 as the other filters may also play a role. In NPrintin 16 you could use variable as a filter and that variable could be expression which was calculated based on other filters placed in the same report/task.
Present us with details on how you apply your variable filter and we will take it from there. Screenshots would help. Think about what we see - we are not there with you so we dont get to see everything, help us understand each step you take and I am sure we will find a solution.
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
The variables are all static and calculated in the load script of the app, no expressions at all. I simply use it for flagging the current fiscal year and fiscal period for example so that i can easily filter my nprinting reports like i used to. for the value of a field driven filter i expect to just be able to put in a value something along the lines of '=$(vCurrentPeriod)' and the filter will be applied.
sorry but you still did not provide any screenshots on how you actually apply your filter using variable. Maybe you are using wrong option from dropdown: "value is" instead of "evaluate or advanced search"?
you should simply use: Evaluate and =$(vCurrentPeriod)