Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
Who can help me with the following:
I have created a few expressions that I named using a formula. (=label)
='W' & week(vStartWeek + 7)
So I have 5 expressions that are named W51 / W52 / W1 / W2 / W3.
But now I would like to use the value of these expressions in a different expression.
='[W' & week(vStartWeek + 7) & ']' is not working, but when I use [W51] it works.
So Qlikview doesn't recognise the name as an expression when i use a formula.
Who can tell me how to enter a variable labelname in a formula?
Try this
$(='[W' & week(vStartWeek + 7) & ']')