Use variable expression name in another expression

[bert_geraerts]

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?

[sunny_talwar · Accepted solution]

Try this

$(='[W' & week(vStartWeek + 7) & ']')