topic what is value list and value loop in QlikView

what is value list and value loop

Anonymous — Thu, 19 Sep 2013 11:15:50 GMT

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

regards

mohan

Re: what is value list and value loop

jonathandienst — Thu, 19 Sep 2013 11:22:56 GMT

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

Re: what is value list and value loop

Thu, 19 Sep 2013 11:34:40 GMT

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

Re: what is value list and value loop

jagan — Thu, 19 Sep 2013 11:35:19 GMT

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.