2 Replies Latest reply: Sep 25, 2014 4:16 AM by Joao Frasco RSS

    Specific Table Format

    Joao Frasco

      Hi

       

      I'm wondering whether you can format a table in a very specific way. I have two dimensions of interest, and I would like to display the second dimension grouped in sections based on the first dimension. The format however, is that the first dimension is used as a separator in the same column as the second dimension, and not as a separate column which is what Qlikview will do by default.

       

      So a table that looks like this (or the equivalent thereof for a pivot table) is what I have.

      Dimension 1Dimension 2Expression 1Expression 2
      Section 1A112
      Section 1B211
      Section 1C310
      Section 2D49
      Section 2E58
      Section 2F67

       

      I want it to look like this:

      Dimension 2Expression 1Expression 2
      Section 1
      A112
      B211
      C310
      Section 2
      D49
      E58
      F67

       

      Is there any way to do this.

       

      Thanks.

       

      Joao.