Unusual Layout of Datasource File_can I somehow pivot 122 headers in QV11?
Hi All,
I need to create a report in QV11 for my customer.
Trouble is that the output .xls file I need to use as my data source has 122 column headers out of which 119 need to be summed up in 3 main areas (to be divided even further into 7 observations per area as this is a sample of 7 patient observations across 3 tools - on my sheet coded as 'BB', '5M', 'HH') .
I attach the file but just to explain what I am after:
I realise (although I am a complete novice) that I cannot possibly pivot all 122 fields and that they need to be somewhat grouped.
I would like to find out whether QV11 functionality will allow me to group them 'thematically' and then sum them appropriately within those 3 groups or do I need to change my output file all together (which I would like to avoid)?
Many thanks to whoever can help out with this.
As I said I am a novice but have all necessary tutorials available so hopefully will catch up quickly.
Yes, unfortunately values at the user-end are 'yes', 'no' and 'N/A' as this is a questionnaire type of data collection.
'Yes' and 'N/A' = 1 while 'No' = 0 so I would like to convert these within the QV application as well as group them there but I am prepared to convert the file before it's loaded if need be.
As for sums, I attach another file - this is what my customer used to see via their old process.
I have transposed these data items for better clarity ('by observation' column) as the layout may not be not immediately obvious having a different number of questions within each tool.
