Create a Straight table without dimensions with each cell representing a measure / field value

[saurabh_Qlik1]

Hi,

I would like to create a straight table without any dimensions with each cell displaying a field value / measure. For example this is an example data set of what I have:

	A	B	C	D	E	F	G	H	I
Player 1	10	20	30	40	50	60	70	80	90
Player 2	100	110	120	130	140	150	160	170	180
Player 3	190	200	210	220	230	240	250	260	270

If I select Company 1 from the filter, I want the output in 3 columns as:

10	40	70
20	50	80
30	60	90

How do I go about achieving this?

Attached is the sample dataset for reference. 

Thanks!

[Or]

I don't think there's any way to force a table to show three lines without a dimension.

[saurabh_Qlik1]

Okay, thank you for your response. I will look for alternatives. 

[edwin]

i would not suggest this as a table with just numbers may not be intuitive for the user.  however, this is interesting.  it is true you need a dimension but you can trick Qlik Sense by converting your measures into dims:

 load * inline [
Company, A, B, C,D,E,F
C1,10,20,30,40,50,60
C2,110,120,130,140,150,160
];

assume C1 is selected:

your dimension is 

=ValueList($(=sum(A)),$(=sum(B)),$(=sum(C)))

your first measure is 

=pick(
match(ValueList($(=sum(A)),$(=sum(B)),$(=sum(C)))
,sum(A),sum(B),sum(C)
),sum(D),sum(E),sum(F))

[edwin]

your aggregation will depend on what you want to use (you can use only, or sum)

this however has one flaw.  the 1st 3 values would have to be unique so if you have 

                              A,   B,   C

CompanyX,  10,  10, 20

your valuelist becomes (10, 10, 20) which will not allow the match to work properly.

[edwin]

one other thing, qlik sense will not allow you to hide the header row.  one more wrench...

[Or · Accepted solution]

That's a clever idea, really, and expanding to work around the issue of identical values could be done with Dual() providing that doesn't create other problems:

=ValueList(Dual($(=sum(A)),1),Dual($(=sum(B)),2),Dual($(=sum(C)),3))

Since the numeric value will be used for the value list, three lines will be created, but the text value will be displayed in the table itself:

[edwin]

takes away one wrench.  too bad Qlik Sense is still in its infancy driving users to create extensions

[edwin]

the dual is the best solution

[saurabh_Qlik1]

Thank you @edwin  and @Or  for your responses. I was able to create the table using your suggestions. However, I ended up not using it and created a table with a fixed dimension column (first column).