topic Re: Difference between value list and value loop in QlikView

Difference between value list and value loop

Sat, 19 Apr 2014 07:13:35 GMT

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

Re: Difference between value list and value loop

Colin-Albert — Sat, 19 Apr 2014 07:26:15 GMT

There is a similar post here.

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

Re: Difference between value list and value loop

tresB — Sat, 19 Apr 2014 07:26:44 GMT

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.

Re: Difference between value list and value loop

Sat, 19 Apr 2014 07:29:14 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.