Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarkharpude
Creator III
Creator III

Rating reports from Excel

Hi,

I have to develop some rating reports based on the raw data. I have attached sample excel for your info.

In excel Raw data is starting from Row 12. And i want to build tables which are just above to that Raw data.

(Tables highlighted in Yellow color).

I am calculating Trainer 1 Knowledge ratings from P column in Raw data and Trainer 1 Overall rating from Q column.  Likewise for Trainer 2 Knowledge ratings from V column in Raw data and Trainer 2 Overall rating from W column.

Other Challenge which i am facing is that Right now we have only 2 trainers, it may be possible that there will be addition of N trainers in future.

So i would be grateful if you could suggest me the optimized way to do that.

Thanks

Sagar

5 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Your data doesn't seem to contain any information about the trainers. You will probably want to use the CrossTable function to pivot the data. See this blog post: The Crosstable Load. You may also want to create a table that maps the scores to the rating labels.


talk is cheap, supply exceeds demand
ThornOfCrowns
Specialist II
Specialist II

What have you tried and what problems did you encounter?

sagarkharpude
Creator III
Creator III
Author

Gysbert, Column P & Q is for Trainer 1 and V & W is for Trainer 2.

Please refer the calculation done in the output table (highlighted table) for details.

sagarkharpude
Creator III
Creator III
Author

James, I am checking the possibility of Concatenation/generic load/cross table but want to know if any optimized way.

sagarkharpude
Creator III
Creator III
Author

Hi Friends,

This is achieved by Cross table and transformation done using concatenation.

Thanks for your support