# ValueList - chart function

ValueList() returns a set of listed values, which, when used in a calculated dimension, will form a synthetic dimension.

Information noteIn 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.

Information noteSynthetic dimensions are not affected by selections.

Syntax:

ValueList(v1 {,...})

Return data type: dual

Arguments:

* v1: Static value (usually a string, but can be a number).
* {,...}: Optional list of static values.

Examples:

Examples and results

| Example | Result |
| --- | --- |
| `ValueList('Number of Orders', 'Average Order Size', 'Total Amount')` | When used to create a dimension in a table, for example, this results in the three string values as row labels in the table. These can then be referenced in an expression. |
| `=IF( ValueList('Number of Orders', 'Average Order Size', 'Total Amount') = 'Number of Orders',<br>count(SaleID),IF( ValueList('Number of Orders', 'Average Order Size', 'Total Amount') = 'Average Order Size',<br>avg(Amount),<br>sum(Amount)<br><br>))<br>` | This expression takes the values from the created dimension and references them in a nested IF statement as input to three aggregation functions, as seen in the below example table. |

Example output in table form

| Created dimension | Year | Added expression |
| --- | --- | --- |
| - | - | 522.00 |
| Number of Orders | 2012 | 5.00 |
| Number of Orders | 2013 | 7.00 |
| Average Order Size | 2012 | 13.20 |
| Average Order Size | 2013 | 15.43 |
| Total Amount | 2012 | 66.00 |
| Total Amount | 2013 | 108.00 |

**Data used in examples:**

`SalesPeople:
` `LOAD * INLINE  [
` `SaleID|SalesPerson|Amount|Year
` `1|1|12|2013` `
2|1|23|2013
` `3|1|17|2013
` `4|2|9|2013
` `5|2|14|2013
` `6|2|29|2013
` `7|2|4|2013` `
8|1|15|2012` `
9|1|16|2012
` `10|2|11|2012
` `11|2|17|2012
` `12|2|7|2012` `
] (delimiter is '|');`