columns in pivot table

[wanyunyang]

Hi guys,

In my data, I have 2 columns: Group1 with values A,B,C, Group2 with values D,E,F. In my qlik sense pivot table, I want to put both columns into same dimension, which should be like: A,B,C,D,E,F. Is it possible?

Thanks for help!

[vamsee]

Are you looking for something like this

Hierarchy in QlikView

[OmarBenSalem]

I can see only one solution (if ur 2 fields contains only FEW values or It'll be long to do...)

Example:

Dim1 : A B C

Dim2 : D E F

Create a dimension in ur pivot table as follow:

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

as a measure:

if( ValueList('A','B','C','D','E','F')='A', sum({<Dim1={'A'}>}Measure),

if( ValueList('A','B','C','D','E','F')='B', sum({<Dim1={'B'}>}Measure),

if( ValueList('A','B','C','D','E','F')='C', sum({<Dim1={'C'}>}Measure),

if( ValueList('A','B','C','D','E','F')='D', sum({<Dim2={'D'}>}Measure),

if( ValueList('A','B','C','D','E','F')='E', sum({<Dim2={'E'}>}Measure),

if( ValueList('A','B','C','D','E','F')='F', sum({<Dim2={'F'}>}Measure)

))))))