Display two dimensions on single row in a pivot table

Sumit2504 — Mon, 20 Dec 2021 21:05:46 GMT

I want to create a structure in Qliksense pivot table similar to the attached image.

In Column A, D1 to D8 are part of 1st dimension then total of that and A1, B2 and c3 are from 2nd dimension.

All data in Column A is from calculated dimension.

Can anyone help me on this?

Re: Display two dimensions on single row in a pivot table

chrismarlow — Mon, 22 Feb 2021 15:55:09 GMT

Hi,

You could try a valuelist with pick/match, which would let you specify formulae for each row, so;

Dimension: =valuelist('D1','D2','D3','D4','D5','D6','D7','D8','Total','A1','B2','C3')

Sorting on that dimension: match(valuelist('D1','D2','D3','D4','D5','D6','D7','D8','Total','A1','B2','C3'),
'D1','D2','D3','D4','D5','D6','D7','D8','Total','A1','B2','C3')

Measure (noddy example): pick(match(valuelist('D1','D2','D3','D4','D5','D6','D7','D8','Total','A1','B2','C3'),
'D1','D2','D3','D4','D5','D6','D7','D8','Total','A1','B2','C3'),1,2,3,4,5,6,7,8,100,5,10,15)

Gives;

So put the formulae you need where bold above. These do get really messy and hard to maintain (in my opinion), a better solution would be to talk your users into something that involves less messing around, maybe as simple as 2 separate tables...

Cheers,

Chris.

topic Display two dimensions on single row in a pivot table in App Development

Display two dimensions on single row in a pivot table

Re: Display two dimensions on single row in a pivot table