3 Replies Latest reply: Mar 15, 2018 8:45 PM by RODELL BASALO RSS

    straight table

    manoj kumar

      Hi All,

       

      I have a straight table consisting of 15 dimensions and measures , I have taken one expression as =Field name.

       

      Data will be like this:

       

      Dimension1, Dimension2,Dimension3,Measure(=Field name)

      a,x,1,100

      b,y,2,100

      c,z,3,200

      a,x,2,100

       

      in this above condition its works fine but if I omit Dimension3 it has to show like this.

      Dimension1, Dimension2,Measure(=Field name)

      a,x,100

      b,y,100

      c,z,,200

      a,x,100

       

      but it is showing

      a,x,100

      b,y,100

      c,z,,200

        • Re: straight table
          Sunny Talwar

          That is because a table can only show a unique combination of rows based on your dimension... because a and x repeat... it only show it once... if you are using this in a straight table, why don't you add dimension 3 as a dimension and then hide it from the presentation tab?

          • Re: straight table
            RODELL BASALO

            as sunny is suggesting

            the best way is to include all dim and hide the 3rd one.

            qlik will automatically group dim with same

            • Re: straight table
              Jyothish KC

              Hi Manoj,

               

              You can also add a field Rowno() from the script and use it to show all the values. You can hide that field as suggested by Sunny,

               

              Load

              rowno() as Sino,

              Dim1,

              Dim2,

              Dim3

              from <>

               

              In the straight chart you can use any dimension with Sino field and hide Sino field from presentation tab.

              Hope it helps.

               

              Br,

              KC