Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

columns in pivot table

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!

2 Replies
vamsee
Valued Contributor

Re: columns in pivot table

Are you looking for something like this

Hierarchy in QlikView

OmarBenSalem
Esteemed Contributor

Re: columns in pivot table

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)

))))))

Community Browser