Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try $(='Financial.NOS '&$(vNextYear))
Try $(='Financial.NOS '&$(vNextYear))