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
How could I combine CM and IS in qlikview
Create a new table with a new dimension:
LOAD * INLINE [
WorkTypeGroup, Work Type
Then use the new WorkTypeGroup as dimension instead of [Work Type]
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...