Value list and field values

[#1]

Is it possible create dimension based on field values and my values.

So I have field with suppliers and I need  dimension with suppliers plus few group of suppliers

[tomasz_tru]

You mean something like this:

https://community.qlikview.com/thread/139175

?

[#3]

No. In this example I need valuelist(a,b,c,d,D1,D2)

[its_anandrjs]

Can you share some sample for this.

[#5]

For example, I have suppliers A,B,C,D.

So I need follow values in my dimension: A,B,C,D, All,All without B, B and D

[lorenzoconforti · Accepted solution]

Create a new table in your data model

Something like this; and then use SupplierGroup to filter

Supplier_Group:

Load * inline

[

Supplier,SupplierGroup

A,A

A, All

A, AllWithoutB

B,B

B,BAndD

….

];

[mdmukramali]

Dear ,

You can use

Dimension: ValueList('A','B','C','D','All','All without B','B and D')

Expression:

Pick(Match(ValueList('A','B','C','D','All','All without B','B and D'),'A','B','C','D','All','All without B','B and D'),

[Expression for A],

[Expression for B],

[Expression for C],

[Expression for D],

[Expression for All],

[Expression for All without B],

[Expression for B and D]

)

Else Share sample File we will help you in a better way,

Thanks,

Mukram.

[#8]

Thx, I think it must work

[#9]

Problem in this, that I have too much suppliers

[#10]

That's why I find way to get value list like valuelist(suppliers,all,all without a, b and d)