Difference between value list and value loop

[#1]

hi can any body tell me what is the diff between value list and value loop

[Colin-Albert]

There is a similar post here.

Please anyone suggest,What is the exact use of valuelist() and valueLoop() in qlikview.

[tresesco]

In ValueList() you give a list explicitly separated by comma, like ValueList(Mem1, mem2, .....), while in ValueLoop() you can give starting and ending values and third parameter to tell the step. That means, if you write valueLoop(10, 20, 2), you get values string from 10 and ending at 20 with gap of 2, so the output : 10,12,14,16,18,20. In short, In ValueLoop() you have to setup a rule to generate values, whereas in ValueList() you have to mention the values itself.

[#4]

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.