what is value list and value loop

[Anonymous]

what is value list and value loop ...pls provide an explanation

regards

mohan

[jonathandienst]

They are used to create artificial dimensions in charts and tables. Valuelist takes an arbitrary list of strings and creates a dimension; valueloop creates a dimension with a number sequence.

Regards

Jonathan

[#3]

From Qlikview Help

Valuelist :  Returns a set of listed values which, when used in a calculated dimension, will form a synthetic dimension.

If Valuelist is used apart from creating synthetic dimensions, it should be used with aggregation function only.

Valueloop : Returns a set of iterated values which, when used in a calculated dimension, will form a synthetic dimension. The values generated will start with the from value and end with the to value including intermediate values in increments of step.

Eg.

Valueloop(1,5,2) returns 1,3,5

[jagan]

Hi,

This functions should be used in Dimension tab of the chart.

ValueList() and ValueLoop() are used to create Dimensions on the fly, for example

ValueList('Value1', 'Value2', 'Value3')

Projects 3 values in the axes.

ValueLoop(StartValue, EndValue, Step Value) -

ValueLoop(2, 10, 2) - This will create a dimensional values 2, 4, 6,8 and 10 and projects along the axis.

Hope this helps you.

Regards,

Jagan.