2 Replies Latest reply: Mar 22, 2017 12:55 PM by Andrew Whitfield RSS

    Charts

    Ramesh Sangana

      Difference between Pivot Table and Straight Table

        • Re: Charts
          Andrew Whitfield

          Why not read the Qlik Help?

           

          Andy

          • Re: Charts
            Andrew Whitfield

            Qlik Help:

             

            https://help.qlik.com/en-US/qlikview/12.1/Content/Home.htm

             

            Pivot Table

              
            An example of a Pivot table 
            Charts are graphical representations of numerical data. The pivot table and the straight table are special cases as they display the data in table form while retaining all the properties of a chart. It is possible to switch between different representations of an existing chart, by changing the Chart Type in the Chart Properties: General page.
            The pivot table is one of the most powerful tools for analyzing data. It offers substantial functionality but is still easy to use. Pivot tables show dimensions and expressions in rows and columns, for example in cross tables. The data in pivot tables may be grouped. Pivot tables can show partial sums.
            The quickest way to create a new pivot table is to select Quick Chart wizard from the Tools  menu.
            By a right-click on the pivot table the Pivot Table: Object Menu  will be displayed. It can also be accessed from the Object  menu, when the pivot table is the active object.

            Straight Table

              

            Charts are graphical representations of numerical data. The pivot table and the straight table are special cases as they display the data in table form while retaining all the properties of a chart. It is possible to switch between different representations of an existing chart, by changing the Chart Type in the Chart Properties: General page.

            In opposition to the pivot table, the straight table cannot display sub-totals or serve as a cross table. On the other hand, any of its columns can be sorted and each of its rows contains one combination of dimension(s)+expression(s).

            The quickest way to create a new straight table is to select Quick Chart wizard from the Tools  menu.

            By a right-click on the straight table the Straight Table: Object Menu  will be displayed. It can also be accessed from the Object  menu, when the straight table is the active object.

             

            Andy