Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

difference between valuelist() and valueloop()

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

please......

Tags (1)
5 Replies
mdmukramali
Valued Contributor II

Re: difference between valuelist() and valueloop()

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.

balkumarchandel
Valued Contributor II

Re: difference between valuelist() and valueloop()

balkumarchandel
Valued Contributor II

Re: difference between valuelist() and valueloop()

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.

Not applicable

Re: difference between valuelist() and valueloop()

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

Not applicable

Re: difference between valuelist() and valueloop()

thanku for ur valuable answer...

Community Browser