5 Replies Latest reply: Jan 20, 2015 9:09 AM by prabhu appu RSS

    Pie Chart with combined columns

      Hey there

       

      In Qlik Sense I like to create a pie Chart with different areas.

      I've two different tables with different column names but with same content.

      It's not possible to rename the columns to the same name.

       

      table1

      has the fieldname name1 with the values: "OK", "NOK"

       

      table2

      has the fieldname name2 with the values: "OK", "NOK"

       

      How can I make a pice chart, witch count's each OK and NOK?

      I like to combine somehow the column name1 and name2 two one column only for createing the pie chart.

       

      Thanks & Regards

      Sarah

        • Re: Pie Chart with combined columns
          Josh Good

          Hi Sarah,

           

          The only solution I could come up with was to combine the two fields into a third field.  Note this doesn't preclude you from also have the fields separate.  Please see attached and below for the QVF and load script I used.

           

          -Josh

          Qlik

           

          Table1:

          LOAD

              Key,

              Field1

          FROM [lib://Desktop/Data.xlsx]

          (ooxml, embedded labels, table is Sheet1);

           

           

          Table2:

          LOAD

              Key,

              Field2

          FROM [lib://Desktop/Data.xlsx]

          (ooxml, embedded labels, table is Sheet2);

           

           

          Table3:

          Load

          Key,

          Field1 as Field3

          Resident Table1;

           

           

          Concatenate(Table3)

          Load

          Key,

          Field2 as Field3

          Resident Table2;