What are Value List

Fri, 06 Feb 2015 14:31:30 GMT

Can you explain about the value list.

Jay

Re: What are Value List

giakoum — Fri, 06 Feb 2015 14:33:09 GMT

Valuelist is used as a custom list of values to use mainly as a calculated dimension

Synthetic Dimension Functions

ValueList (value {, value })

Returns a set of listed values which, when used in a calculated dimension, will form a synthetic dimension. In charts with a synthetic dimension created with the valuelist function it is possible to reference the dimension value corresponding to a specific expression cell by restating the valuelist function with the same parameters in the chart expression. The function may of course be used anywhere in the layout, but apart from when used for synthetic dimensions it will only be meaningful inside an aggregation function.

Examples:

valuelist ( 1, 10, 100 )

valuelist ( 'a', 'xyz', 55 )

ValueLoop(from [, to [, step = 1 ]])

Returns a set of iterated values which, when used in a calculated dimension, will form a synthetic dimension. The values generated will start with the from value and end with the to value including intermediate values in increments of step. In charts with a synthetic dimension created with the valueloop function it is possible to reference the dimension value corresponding to a specific expression cell by restating the valueloop function with the same parameters in the chart expression. The function may of course be used anywhere in the layout, but apart from when used for synthetic dimensions it will only be meaningful inside an aggregation function.

Examples:

valueloop ( 1, 3 ) returns the values 1, 2 and 3

valueloop ( 1, 5, 2 ) returns the values 1, 3 and 5

valueloop ( 11 ) returns the value 11

Re: What are Value List

Fri, 06 Feb 2015 14:43:13 GMT

Please explain with an example.

Thanks

Re: What are Value List

giakoum — Fri, 06 Feb 2015 14:46:56 GMT

http://community.qlik.com/docs/DOC-5011

Re: What are Value List

Fri, 06 Feb 2015 14:53:02 GMT

Hi,

Here you have an example - it comes from great book "QlikView for Developers Cookbook" by Stephen Redmond, which I strongly recommend

Look at Properties of the chart. One dimension is calculated, and you can name any values you want.

Check expression definition on Expressions tab - there is:

If(ValueList(1,2)=1, 0, Sum(Sales))

So you can manually give any value for every dimension you created.

It is very convenient!

Regards,

Bartek

topic Re: What are Value List in QlikView

What are Value List

Re: What are Value List

Synthetic Dimension Functions

Re: What are Value List

Re: What are Value List

Re: What are Value List