Use variable expression name in another expression

bert_geraerts — Mon, 03 Dec 2018 14:15:19 GMT

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?

Re: Use variable expression name in another expression

sunny_talwar — Mon, 03 Dec 2018 14:19:45 GMT

Try this

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

topic Re: Use variable expression name in another expression in QlikView

Use variable expression name in another expression

Re: Use variable expression name in another expression