How to combine rows or columns of excel data in qlik
Let's say I have a spreadsheet that looks something like this:
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...
Re: How to combine rows or columns of excel data in qlik
New question that is kinda related to the last one. I have a very large excel sheet that I am loading into qlik. There is a column heading called "PERSONGROUP" that has about 50-60 different inputs which should really be grouped into about 10-15 input groups (i.e. 'IC', 'IC1', 'IC2', 'IC3' should be 'IC' and 'FAC', 'FAC1' should be 'FAC', etc.). What do I need to do so that all of these inputs are grouped together the way I want them to be? I tried using multiple dimensions with the =if(match(...)) that Vish suggested to use in the chart script, but that only worked for combining one group...