Discussion board where members can get started with Qlik Sense.
I am having trouble with the syntax in my set analysis. I am trying to change the top formula to a formula that adjusts for each month as the year progresses. I need help with the syntax in the bottom formula:
vLastMonthEnd is a variable that returns 2018-11-30, so I'm trying to get to the month number in the formula.
Thanks in advance for any help you can provide!
Go to Solution.
I think I figured it out. I needed to create the variable first, then use it in the syntax. It now works with the variable that I created:
Thank you so much for your quick response! Have a great evening!
Can you post the definition of vLastMonthEnd?
Please disregard. I figured out that I should create the variable first, then use it in my syntax.