Hi - I previously posted and gained an answer for only selecting certain values within a straight table. https://community.qlik.com/t5/New-to-QlikView/Only-include-certain-values-in-straight-table/m-p/8267...
I now have a requirement to select based on a variable being included in the set expression.
If i set the expression like the following it works:
But when I set it like the below it doesnt:
The variable is working fine and is the following:
vCurrentMonth is =MonthName(Today(1))
What am I doing wrong. the field in question it is validating has been derived and shows Nov 2018
Any ideas welcome thank you in advance.