Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Are you looking for something like this
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)
))))))