topic Re: Getting current value of valueList or valueLoop in QlikView

Getting current value of valueList or valueLoop

bertrand_herard — Mon, 15 Sep 2014 09:30:53 GMT

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

Re: Getting current value of valueList or valueLoop

tresB — Mon, 15 Sep 2014 09:34:27 GMT

Use the same valuelis()/valueloop() expression in the expression tab. Like:

Dimension: ValueList(1,2)

Expression: ValueList(1,2)

Re: Getting current value of valueList or valueLoop

bertrand_herard — Mon, 15 Sep 2014 09:40:07 GMT

As far as I know, ValueList and ValueLoop functions do not work in Expressions in graph, are they ?

If I'm wrong, can you please send me a little example ?

Regards

Re: Getting current value of valueList or valueLoop

tresB — Mon, 15 Sep 2014 09:46:39 GMT

Yes, they do. It would be better, if you could explain your requirement in more details with a sample qvw.

Re: Getting current value of valueList or valueLoop

bertrand_herard — Mon, 15 Sep 2014 09:51:17 GMT

Here is what I'm trying to do : in a grah

I've a calculated dimension in a graph with value = ValueList(2010,2014).

In Expressions i'd like to have a difference behaviour depending of the current value of valuelist (exemple :

If ValueList current value <=2012, the expression returns the same value as the valuelist, if ValueList>2012 the expressions returns Valuelist value -1.

Re: Getting current value of valueList or valueLoop

tresB — Mon, 15 Sep 2014 09:54:04 GMT

Try this in expression:

=If(ValueList(2010,2014)<=2012, ValueList(2010,2014), -1)

Re: Getting current value of valueList or valueLoop

MarcoWedel — Mon, 15 Sep 2014 10:17:30 GMT

=If(ValueList(2010,2014)<=2012, ValueList(2010,2014), ValueList(2010,2014)-1)

Re: Getting current value of valueList or valueLoop

MarcoWedel — Mon, 15 Sep 2014 10:19:20 GMT

=ValueList(2010,2014)+(ValueList(2010,2014)>2012)

Re: Getting current value of valueList or valueLoop

tresB — Mon, 15 Sep 2014 10:20:28 GMT

Did he mean that?. Hope he understood how it works and modified according to his requirement.

Re: Getting current value of valueList or valueLoop

bertrand_herard — Mon, 15 Sep 2014 13:43:52 GMT

Thanks your answers helped me,

I've manage to build my expression =If(ValueLoop(2010,2014)<=2012, ValueLoop(2010,2014), -1).

Unfortunately my final goal was to put this expression in a Set Analysis like this :

sum({<Year={

If(ValueLoop(2010,2014)<=2012, ValueLoop(2010,2014), -1)

}> MyIndic)

I've an issue : if I use the expression in $() it evaluate only one value of it for the whole table /graph

Any idea about this ?

Regards

Re: Getting current value of valueList or valueLoop

bertrand_herard — Wed, 17 Sep 2014 08:51:18 GMT

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

Regards

Re: Getting current value of valueList or valueLoop

tresB — Wed, 17 Sep 2014 09:05:06 GMT

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))

)

Re: Getting current value of valueList or valueLoop

bertrand_herard — Mon, 06 Oct 2014 08:06:01 GMT

OK Thanks !