I have a issue management spreadsheet where a specific item can have multiple repair instances. How do I combine multiple fields/columns from a spreadhsheet into one demension.
I'm trying to get a count of the items in the Repairs Performedx fields
Solved! Go to Solution.
[EDIT: Now with qvw attached]
I have changed your load script & it now loads ok.
You'll need to change the path to xlsx and the xlsx name though, to suit where you keep it.
crosstable ( [Repair Number] , [Repair Type] , 9)
Year ([Received for Repair]) as received_year ,
Month ([Received for Repair]) as received_Month ,
Week ([Received for Repair]) as received_week ,
[Received for Repair],
[12.18.13 Fuse Scopes Repair Spreadsheet (1).xlsx]
(ooxml, embedded labels, table is [QlikView spreadsheet]);
The crosstable() statement was missing and then needed adjusting.
Best Regards, Bill
Thanks Bill. I'm positive my explanation was not clear. What I am looking for is total number by repair. You are close but I do not need Repair Performed Separated by instance but need total of all instances Does that make sense?
Example, How many times does 'adjust angulation' occur regardless of column its reported in.
Yes. How would I combine all 5 into one dimension?
How many total 'adjust angulation' are there, regardless of where they show up in the columns.
I've attached my qvw with your objects on the last tab. Could you take a look. If I implement the script code you provided my current objects blow up. Not sure what I am doing wrong. It would be great if I could have your help by 530 as I have a meeting to present this data.
Thank you very much!!