Variable in data name

karolina_ — Tue, 23 Jul 2013 12:53:22 GMT

Hi,

I would like to have dynamicly choosen data by qv document.

Let assume I want to dispaly data [Financial.NOS 2013] and [Financial.NOS 2014].

Since 1.01.2014 I would like to display data [Financial.NOS 2014] and [Financial.NOS 2015].

From script i'm loading:

let vCurrentYear=Year(Today());

let vNextYear=$(vCurrentYear)+1;

I want to display the data in the bar chart as expression. If I put in label

='NOS '&$(vCurrentYear)

='NOS '&$(vNextYear)

it is displayed correctly.

However if I do similar in definition:

='[Financial.NOS '&$(vCurrentYear)&']'

='[Financial.NOS '&$(vNextYear)&']'

it does not show any data.

Does anyone know how can I put variable in data name?

Cheers,

Karolina

Re: Variable in data name

Gysbert_Wassenaar — Tue, 23 Jul 2013 12:56:34 GMT

Try $(='Financial.NOS '&$(vNextYear))