3 Replies Latest reply: Sep 18, 2012 11:16 AM by Gregorio Zerpa RSS

    Pivot Problem

    Helen Pippard

      Hello

       

      I am fairly new to Qlikview and need some advice

       

      Could someone kindly advise me how with using dummy fields "Admitted" and "Non Admitted" how I can get the two dummy fields to show on the left hand side of a pivot table

       

      The example below shows them as seperate, but I ideally want them to appear in a very similar format in 1 pivot table

       

       

       

      I ideally would like to look as follows in one table (Kind of):

       

       

       

      Thanks

      Helen

        • Re: Pivot Problem

          Hi Helen,

           

               If data is supported in diferents tables you can concatenate those making the dummyu field like that,

           

          Table1:

               LOAD A   

                         B

                         'Admitted'           as Status;

               SQL SELECT A,B FROM TABLE

           

          cocatenate(Table1):

               LOAD A

                         B

                         'Non-Admitted'       as Status;

               SQL SELECT A,B FROM TABLE2

           

          I hope to help you.

            • Re: Pivot Problem
              Helen Pippard

              Hello,

               

              Thank you for your reply

               

              The data is all coming from one table, but my problem is getting more than one dummy field to show on the left hand side of the pivot table

                • Re: Pivot Problem

                  Hi Helen,

                   

                       In this case you add a calculated dimensión in you pivot table, this dimension evalueta an expresion to determinate if is an addmited or not value.

                   

                  To add a calculate dimension Pivot Table Properties --> Tab Dimensión --> Button Calculated dimension.

                   

                  I hope to help you.