What is ValueList?

[#1]

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

[jvitantonio]

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)

[jagan · Accepted solution]

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.

[shantanu73]

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

[jagan]

Hi,

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

Regards,

Jagan.

[#6]

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?

[swuehl]

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.

[#8]

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

Filling Missing Data

[dineshraj]

Hi jagan,

Can we display date in value list?

[jagan]

Yes.

Regards,

Jagan.