2 Replies Latest reply: Mar 9, 2018 1:40 PM by omar bensalem RSS

    columns in pivot table

    Wanyun Yang

      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!

        • Re: columns in pivot table
          vamsee duggirala

          Are you looking for something like this

           

          Hierarchy in QlikView

          • Re: columns in pivot table
            omar bensalem

            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)

            ))))))