Getting current value of valueList or valueLoop

[bertrand_herard]

Hi,

When using a synthetic Dimension in a chart with functions like ValueList() ou ValueLoop(). Is there any way to display the current dimension value in Expressions ?

(I’m using Rowno() function but I would like to get the Dimension Value).

Regards

[bertrand_herard]

OK

I've attached a "sandbox" qvw  to explain my last point

Regards

[tresB · Accepted solution]

Set analysis gets evaluated once for an objcet(NOT row-wise), try with 'if' like:

=If(ValueLoop(2010,2014)<=2013,

sum(If(Year=ValueLoop(2010,2014),Value)),

sum(If(Year=ValueLoop(2010,2014)-1,Value))

)

[bertrand_herard]

OK Thanks !