Display two dimensions on single row in a pivot table

[Sumit2504]

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?

[chrismarlow]

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.