5 Replies Latest reply: Mar 21, 2013 8:16 AM by ankitg786 RSS

    list report and crosstab

      Is it possible to create list reports and crosstabs in qlikview. If possible ,Please suggest steps to achieve it.

        • list report and crosstab
          Deepak Kurup

          Can you give an example of the format for list reports. Cross tab : yes it is possible. Use pivot table in the chart properties and drag the dimesnion to top get the cross tab report

            • list report and crosstab

              A list report is a simple report as a simple table

              eg

               

              sl no, col1, col2, col3

              1

              2

              3

               

               

              • Re: list report and crosstab

                Hi

                 

                I want to create a cross tab like this

                 

                 

                      A1   A2  

                M1  C1  C2

                 

                M2  C1  C2

                 

                M3   C1  C2

                 

                 

                Here A1 & A2 are values coming from one dimension.

                M1 and M2 are row values for a crosstab, coming from another dimension

                C1 and C2 are charts (Pie charts) to be calculated based on dimensions used in Rows and columns plus one other dimension.

                 

                Could you please give me a hint on how to do it.

                 

                Thanks

                Ankit

                • Re: list report and crosstab

                  Hi

                   

                  I want to create a cross tab like this

                   

                   

                        A1   A2  

                  M1  C1  C2

                   

                  M2  C1  C2

                   

                  M3   C1  C2

                   

                   

                  Here A1 & A2 are values coming from one dimension.

                  M1 and M2 are row values for a crosstab, coming from another dimension

                  C1 and C2 are charts (Pie charts) to be calculated based on dimensions used in Rows and columns plus one other dimension.

                   

                  Could you please give me a hint on how to do it.

                   

                  Thanks

                  Ankit