topic Re: Value list and field values in QlikView

Value list and field values

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Value list and field values

tomasz_tru — Mon, 02 Oct 2017 07:08:33 GMT

You mean something like this:

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

Re: Value list and field values

Mon, 02 Oct 2017 07:24:24 GMT

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

Re: Value list and field values

its_anandrjs — Mon, 02 Oct 2017 07:30:30 GMT

Can you share some sample for this.

Re: Value list and field values

Mon, 02 Oct 2017 07:34:28 GMT

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

Re: Value list and field values

lorenzoconforti — Mon, 02 Oct 2017 07:45:36 GMT

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

….

];

Re: Value list and field values

mdmukramali — Mon, 02 Oct 2017 08:03:19 GMT

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.

Re: Value list and field values

Mon, 02 Oct 2017 08:10:11 GMT

Thx, I think it must work

Re: Value list and field values

Mon, 02 Oct 2017 08:11:58 GMT

Problem in this, that I have too much suppliers

Re: Value list and field values

Mon, 02 Oct 2017 08:13:51 GMT

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

Re: Value list and field values

lorenzoconforti — Mon, 02 Oct 2017 10:40:03 GMT

Hi, please mark the post as Answered if you are happy with the feedback