I am new to Nprinting and wanted to know if it was possible to have a filter based on a variable?
For example, the document I use has a variable (vLastMonth), and I want to filter a field (Acctg Mon) to whatever the last month was so the report is created only showing the data from the past month. I tried using =vLastMonth and just vLastMonth in the value for the field filter.
When I brought them into the report and applied them to the image, I was getting an error on my charts that said it couldn't be calculated.
Am I missing some step somewhere in the process of applying a filter with a variable expression, or is this not the right way to go about this.
I read through the article below but couldn't find anything related to this specific problem.
Or you can have a dynamic filter based on a QlikView expression. What is the logic behing vLastMonth? If it is something like month(now)-1, then you can use that syntax in the value column, and not use the variable at all. You would have to check "Evaluate" if using this method.