4 Replies Latest reply: Sep 23, 2016 5:28 PM by Vishwarath Nagaraju RSS

    How to combine rows or columns of excel data in qlik

    jacob meredith

      Let's say I have a spreadsheet that looks something like this:

       

      WO#Work TypeLABCOSTOHCOST

      111

      PM10050
      112PM0100
      113CM200200
      114LB0400
      115IS500

       

       

      If I wanted to make a bar graph that compares the sum of the costs of each Work Type, how can I make qlikview sum LABCOST and OHCOST without making another column in my spreadsheet (so the sum of the costs would be 250 for PM, 400 for CM, etc.). Also, How could I combine CM and IS in qlikview so when I made a similar bar graph it would show the costs for PM, LB, and a third Work Type that is a combo of CM and IS? My spreadsheet has >500,000 rows of data, so making these changes in excel would be a pain...