topic Re: difference between valuelist() and valueloop() in QlikView

difference between valuelist() and valueloop()

Tue, 06 Jan 2015 12:29:57 GMT

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

please......

Re: difference between valuelist() and valueloop()

mdmukramali — Tue, 06 Jan 2015 12:42:23 GMT

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.

Re: difference between valuelist() and valueloop()

Anonymous — Tue, 06 Jan 2015 12:43:02 GMT

Synthetic Dimensions with Better Performance than Valuelists « BI Commons

Re: difference between valuelist() and valueloop()

Anonymous — Tue, 06 Jan 2015 12:47:58 GMT

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.

Re: difference between valuelist() and valueloop()

Tue, 06 Jan 2015 12:59:40 GMT

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

Re: difference between valuelist() and valueloop()

Tue, 06 Jan 2015 15:55:38 GMT

thanku for ur valuable answer...