What is the difference between ValueList() and ValueLoop()?

Thu, 28 Feb 2013 05:44:44 GMT

Hi All,

Difference ValueList() and ValueLoop()

please explain with examples...

Re: What is the difference between ValueList() and ValueLoop()?

Thu, 28 Feb 2013 05:50:24 GMT

For example, create a calculated dimension in a straight table:

=ValueList('KPI1','KPI2')

Then, an expression like

=pick(match(

ValueList('KPI1','KPI2')

,'KPI1','KPI2')

,sum(FIELD)

,count(FIELD)

)

You'll get a dimension with two value, KPI1 and KPI2. To check in your expression, which is the current dimension value, you'll need to repeat the Valuelist() function as used in the dimension again in the expression. (Above can also be written as

=if( ValueList('KPI1','KPI2') = 'KPI1', sum(FIELD),

if( ValueList('KPI1','KPI2') = 'KPI2', count(FIELD) ))

So you can create a dimension on the fly in a chart which is not based on a field in your data model (I think that's why its called synthetic).

Valuelist() just uses the values you are listing as arguments, valueloop creates the dimension values based on start, end and step values.

Re: What is the difference between ValueList() and ValueLoop()?

Fri, 01 Mar 2013 09:51:53 GMT

Practicle example:

http://community.qlik.com/message/222888#222888

topic Re: What is the difference between ValueList() and ValueLoop()? in QlikView

What is the difference between ValueList() and ValueLoop()?

Re: What is the difference between ValueList() and ValueLoop()?

Re: What is the difference between ValueList() and ValueLoop()?