topic Re: What is ValueList? in QlikView

What is ValueList?

Fri, 23 Mar 2012 10:42:35 GMT

I am new to qlikview, when i was trying out calculated dmensions read a function named Valuelist ..i didnt get any help from qlikview help,,,

So can anyone explain it to me with an example ??

Thank You in advance

What is ValueList?

jvitantonio — Fri, 23 Mar 2012 13:07:44 GMT

ValueList will simple display a list of values inside the ()

For example, create a list box go to Expressions and put =ListValue(1,2,3,4)

Tihs will create a list box with these values inside. This is the same as =ListLoop(1,4)

Re: What is ValueList?

jagan — Fri, 23 Mar 2012 14:04:18 GMT

Hi,

ValueList() is used to create Temporary Dimension or used to create a List box as Qlikuser said.

Hope the sample attachment helps you.

Regards,

Jagan.

Re: What is ValueList?

shantanu73 — Tue, 26 Feb 2013 06:45:50 GMT

Hello Jagan,

I had seen ValueList Experession.qvw file which is very good example of Valuelist Function. But I am in confuse. If will be great if u explain the following script.

In the Chart->Dimension instead of field name there is script:-

=ValueList('Product Breedte', 'Product Diepte', 'Product Kwaliteit Product Diepte', 'Product onderscheidendheid', 'Product voorradigheid')

I want to know whether 'Product Breedte', 'Product Diepte', etc is field name or Field value.

Can u please explain how it workout.

Thanks In Advance

Shantanu

Re: What is ValueList?

jagan — Tue, 26 Feb 2013 13:30:35 GMT

Hi,

'Product Breedte', 'Product Diepte', etc are the field values of the Temporary Dimension.

Regards,

Jagan.

Re: What is ValueList?

Sat, 04 Jan 2014 13:28:18 GMT

Hi jagan,

Even I am new to QV and understanding the basics. My question, if I create a ValueList(1,2,3,4) and create a list. I can see the values 1,2,3 and 4 in the list but unable to select either of them. Can you please advise why I cannot select them?

Re: What is ValueList?

swuehl — Sat, 04 Jan 2014 14:08:14 GMT

Rahul,

you can only select values that are originating from fields in your data model (created from your load script).

So it's not possible to select ValueList created synthetic dimension values.

Create a field in your data model instead.

Re: What is ValueList?

Thu, 25 Sep 2014 14:41:40 GMT

Yet another example of ValueList whose values in the Value list are same as the data in the datamodel.

Filling Missing Data

Re: What is ValueList?

dineshraj — Thu, 11 Aug 2016 06:19:24 GMT

Hi jagan,

Can we display date in value list?

Re: What is ValueList?

jagan — Thu, 18 Aug 2016 03:22:52 GMT

Yes.

Regards,

Jagan.

Re: What is ValueList?

gauravsinghtomar — Fri, 13 Mar 2020 14:49:58 GMT

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

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', count(SaleID), IF( ValueList('Number of Orders', 'Average Order Size', 'Total Amount') = 'Average Order Size', avg(Amount), sum(Amount) ))

This expression takes the values from the created dimension and references them in a nested IF statement as input to three aggregation functions:

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 '|');