I was always able to get it to resolve to CurrentQuarter.Q1.CV in the Label even with my old statement of
'CurrentQuarter.Q' & (Right('$(vCurrentQuarter)',1)-1) & '.CV' using without the num function.
But in the expression, in conjuntion of the sum function, Qlikview is not able to retrieve data from the CurrentQuarter.Q1.CV column.
It is how Qlikview expects a non-string variable that is the puzzle that I am trying to solve.
=sum('CurrentQuarter.Q' & (Right('$(vCurrentQuarter)',1)-1) & '.CV')
that's equivalent to
which results to nothing.
But if we can somehow make it so it is NOT a string, it would work.
The question is how?
This is great!
I ended up reading more about this $-sign expansion here for the other people that got stumped.
Thanks again to whoever that helped out.