5 Replies Latest reply: Apr 13, 2016 9:56 PM by Settu Periyasamy RSS

    Table Layout (combination of dimensions & expressions)

    Nik Bach

      Hello Experts,

      my customer want to have a very special table layout, shown below.

       

       

      screenshot1.png

      The layout-order of dimensions and expressions in the table seems to be tricky.

      Is ist possible to create such layout in Qlik at all?

       

      It seems to me, if my dimensions (blue) are placed as rows and expressions (red) are placed as columns, I cannot set an expression (yellow)  as row, too.

       

      Does anyone have a similar layout already in place, as qlik-file, maybe?

       

      Thanks

      Nik

        • Re: Table Layout (combination of dimensions & expressions)
          Settu Periyasamy

          Hi,

          May be you can try with ValueList, Pick and match functions.

          for e.g

          LOAD * INLINE [
          Dim, Year, Sales
          Health, 2015, 1928
          Insurance, 2015, 1523
          Manufacturing, 2015, 1363
          Health, 2016, 1967
          Insurance, 2016, 1831
          Manufacturing, 2016, 1420
          ]
          ;

           

          Create one Variable:

          vDim : =Concat(DISTINCT chr(39)&Dim&chr(39),',')&',''Priority-Level''

           

          Then, Choose Straight Table Chat.

           

          Dim          :      =ValueList($(vDim))

          Expr 2015    :  =Pick(Match(ValueList($(vDim)),'Health','Insurance','Manufacturing','Priority-Level'),
                                   
          sum({<Year={2015},Dim={'Health'}>}Sales),
                                   
          sum({<Year={2015},Dim={'Insurance'}>}Sales),
                                   
          sum({<Year={2015},Dim={'Manufacturing'}>}Sales),
                                   
          Ceil(Rand()*5))

          Expr 2016: =Pick(Match(ValueList($(vDim)),'Health','Insurance','Manufacturing','Priority-Level'),

                          sum({<Year={2016},Dim={'Health'}>}Sales),
                         
          sum({<Year={2016},Dim={'Insurance'}>}Sales),
                         
          sum({<Year={2016},Dim={'Manufacturing'}>}Sales),
                         
          Ceil(Rand()*5))

           

          Capture.JPG