Discussion board where members can get started with Qlik Sense.
I am trying to apply the year filter to the column in the left but unfortunately i'm not getting any results. (Its zero)
Below is the set analysis string im applying:
MNDATE has starting dates of each month, like (20160101.... 20161201) and my variable vRepYrCrnt=2016
Your help will be much appreciated.
Go to Solution.
Create a year field in the script:
Year(MNDATE) as Year
and then this
Huh... why this didn't strike to me? Yeah this is the way ahead and it works! Thanks Sunny!