1 Reply Latest reply: Jul 23, 2013 8:56 AM by Gysbert Wassenaar RSS

    Variable in data name

    Karolina Papaj

      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