Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ishanbansal1204
New Contributor

2 dimensions for value list

Hi Experts,

I have been working on 1 dimension value list but the current requirement wants to me take up 2 dimension value list.

The first dimension is

=ValueList('A','B','C','D','E','F')


For the above value list, how do i create another value list against the value from the first

A    Z

A    X

B    Y

C    U

D    P

E    K

F   L

The output is given above.

6 Replies
agigliotti
Honored Contributor II

Re: 2 dimensions for value list

why are you thinking to use ValueList for your use case?

ishanbansal1204
New Contributor

Re: 2 dimensions for value list

The current dashboard that i am working on is basically related to KPI's and it has 2 dimensions  and 5 different columns who values has to be calculated cell by cell.

Is there an another way of doing this.?

Please let me know if its possible?

Thanks,

Ishan

agigliotti
Honored Contributor II

Re: 2 dimensions for value list

ok so you should add another ValueList dimension and check the combination of both dimensions values in your 5 measures expressions.

ishanbansal1204
New Contributor

Re: 2 dimensions for value list

Absolutely. Thats right.

krishna_2644
Valued Contributor III

Re: 2 dimensions for value list

something like this?


1.PNG

stascher
Contributor II

Re: 2 dimensions for value list

If you know what the values are going to be, you might create a simple inline table and iterate over it's values.

Temp:

load * inline [

dim1,dim2

A,Z

A,X

B,Y

C,U

D,P

E,K

F,L

];

then use dim1 and dim2 in your visualization instead of value loops. May not work if you need actual relationship between dims and the data your measuring

Community Browser