Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
karolina_
Creator II
Creator II

Variable in data name

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)

or

='NOS  '&$(vNextYear)

it is displayed correctly.

However if I do similar in definition:

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

or

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

it does not show any data.

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

Cheers,

Karolina

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand