Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

value loop?

Hi

what is value loop and value list with eexamples

1 Solution

Accepted Solutions
MVP
MVP

Re: value loop?

Hi,

ValueLoop() and ValueList() are used to create synthetic dimensions in a chart, ValueLoop() is used to generate a numeric values dimension and ValueList() is used for both numeric and string with predefined values.

ValueLoop() and ValueList() should be used in a Calculated dimension.

Example:

=ValueLoop(1, 100, 2) - This will generate dimensional values of 1, 3,5, ....99

=ValueList('Value1', 'Value2', 'Value3') - This will generate dimensional values of Value1, Value2, Value3.

Hope this helps you.

Regards,

Jagan.

2 Replies
MVP
MVP

Re: value loop?

Hi,

ValueLoop() and ValueList() are used to create synthetic dimensions in a chart, ValueLoop() is used to generate a numeric values dimension and ValueList() is used for both numeric and string with predefined values.

ValueLoop() and ValueList() should be used in a Calculated dimension.

Example:

=ValueLoop(1, 100, 2) - This will generate dimensional values of 1, 3,5, ....99

=ValueList('Value1', 'Value2', 'Value3') - This will generate dimensional values of Value1, Value2, Value3.

Hope this helps you.

Regards,

Jagan.

MVP
MVP

Re: value loop?

Hi,

Check this link

Synthetic Dimensions - ValueList() (Example)


Regards,

Jagan.