difference between valuelist() and valueloop()

[#1]

hi frnds can any tell me the difference between valuelist() and valueloop()

please......

[mdmukramali]

Dear,

ValueList just lists some values to use as calculated dimension

eg valuelist('a','b',c') will list values a, b and c.

ValueLoop will generate a series of numbers starting with the first parameter, ending with 2nd and having the 3rd as step.

ValueLoop(1,9,2) will generate values 1, 3, 5, 7, 9

ValueLoop(1,6,1) will generate values 1, 2, 3, 4, 5, 6

valuelist(1,2,3,4,5,6) is equivalent to ValueLoop(1,6,1)

Thanks,

Mukram.

[Anonymous]

Synthetic Dimensions with Better Performance than Valuelists « BI Commons

[Anonymous]

Mukram is correct ...

Instead of using a valuelist or valueloop with a calculated dimension, you can create a field in your data model with dual values that correspond with the label and row number of the field value. This can be placed in an island table that does not connect to your data model. Then this can be used instead of the calculated dimension in your charts.

[#5]

Hi Shaik,

have a look at the below, should aid your understanding

http://community.qlik.com/blogs/qlikviewdesignblog/2013/07/01/valuelist-for-those-tricky-situations

hope that helps

Joe

[#6]

thanku for ur valuable answer...