topic Re: Rating reports from Excel in QlikView

Rating reports from Excel

sagarkharpude — Thu, 07 Apr 2016 07:02:45 GMT

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

Re: Rating reports from Excel

Gysbert_Wassenaar — Thu, 07 Apr 2016 09:27:17 GMT

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.

Re: Rating reports from Excel

ThornOfCrowns — Thu, 07 Apr 2016 09:38:38 GMT

What have you tried and what problems did you encounter?

Re: Rating reports from Excel

sagarkharpude — Thu, 07 Apr 2016 09:57:01 GMT

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.

Re: Rating reports from Excel

sagarkharpude — Thu, 07 Apr 2016 10:01:03 GMT

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

Re: Rating reports from Excel

sagarkharpude — Tue, 10 May 2016 10:05:04 GMT

Hi Friends,

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

Thanks for your support