topic Re: Calculation of Rating in QlikView https://community.qlik.com/t5/QlikView/Calculation-of-Rating/m-p/1255254#M852843 <HTML><HEAD></HEAD><BODY><P>Based on the appraisal from date and to date, I have to show all the employee's rating for six months, i.e it should be the aggregate value of six months. I need to show current rating and previous rating for each employee.</P><P>current rating - last 6 months</P><P>Previous rating - previous 6 months to current rating</P></BODY></HTML> Thu, 23 Feb 2017 15:27:09 GMT Anonymous 2017-02-23T15:27:09Z Calculation of Rating https://community.qlik.com/t5/QlikView/Calculation-of-Rating/m-p/1255250#M852839 <HTML><HEAD></HEAD><BODY><P>Guys,</P><P>I am having employee's rating monthly wise. I need to show these ratings into two halves like first half and second half.</P><P>For the first half, 1st six months and for second half, 2nd six months. I have to consolidate all the six month ratings and need to show for each half. But the problem here is each employee has different date and I need to show dynamically. Please help... and also share some script code to achieve this.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Calculation-of-Rating/m-p/1255250#M852839 Anonymous 2020-11-25T16:16:04Z Re: Calculation of Rating https://community.qlik.com/t5/QlikView/Calculation-of-Rating/m-p/1255251#M852840 <HTML><HEAD></HEAD><BODY><P>Can you provide sample data in excel file (10 to 15 lines would be OK)</P></BODY></HTML> Thu, 23 Feb 2017 14:11:31 GMT https://community.qlik.com/t5/QlikView/Calculation-of-Rating/m-p/1255251#M852840 MK_QSL 2017-02-23T14:11:31Z Re: Calculation of Rating https://community.qlik.com/t5/QlikView/Calculation-of-Rating/m-p/1255252#M852841 <HTML><HEAD></HEAD><BODY><P>Thank you, please find the attachment from original discussion.</P></BODY></HTML> Thu, 23 Feb 2017 14:55:44 GMT https://community.qlik.com/t5/QlikView/Calculation-of-Rating/m-p/1255252#M852841 Anonymous 2017-02-23T14:55:44Z Re: Calculation of Rating https://community.qlik.com/t5/QlikView/Calculation-of-Rating/m-p/1255253#M852842 <HTML><HEAD></HEAD><BODY><P>Based on the file you have provided, can you give us little description about what you want to achieve and which date field we have to use?</P></BODY></HTML> Thu, 23 Feb 2017 15:05:25 GMT https://community.qlik.com/t5/QlikView/Calculation-of-Rating/m-p/1255253#M852842 MK_QSL 2017-02-23T15:05:25Z Re: Calculation of Rating https://community.qlik.com/t5/QlikView/Calculation-of-Rating/m-p/1255254#M852843 <HTML><HEAD></HEAD><BODY><P>Based on the appraisal from date and to date, I have to show all the employee's rating for six months, i.e it should be the aggregate value of six months. I need to show current rating and previous rating for each employee.</P><P>current rating - last 6 months</P><P>Previous rating - previous 6 months to current rating</P></BODY></HTML> Thu, 23 Feb 2017 15:27:09 GMT https://community.qlik.com/t5/QlikView/Calculation-of-Rating/m-p/1255254#M852843 Anonymous 2017-02-23T15:27:09Z