topic Need help in QlikView https://community.qlik.com/t5/QlikView/Need-help/m-p/1349767#M820502 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>My requirement is as below</P><P></P><P>I have a review done by for each resources by Internal and External for few categoires. The resources are rated based on each Category on a scale of 1 to 10. if rating value is NA which means the resource has not been rated for that category and should not be considerd for calculation. For example Name1 has been rated for 3 Categories</P><P></P><P>Condition 1: The resources would be considered as <STRONG>Excellent</STRONG> by Internal if only rating for all the categories for which he is rated is &gt;7</P><P>Condition 2: <SPAN style="font-size: 13.3333px;">The resources would be considered as </SPAN><SPAN style="font-size: 13.3333px;"><STRONG>Excellent</STRONG></SPAN><SPAN style="font-size: 13.3333px;"> by External if only rating for all the categories for which he is rated is &gt;7</SPAN></P><P></P><P>If the resource is EXCELLENT in both Internal and Extrenal over all valid Categories , Then the resource will be considered as <STRONG>Overall Excellent</STRONG></P><P></P><P>I just want to create a chart which will tell me total no of resources and how many of them has <STRONG>overall as Excellent . The chart should have 3 columns</STRONG></P><P></P><P>Any dimension , Total No of Resources for that dimension and Total no of Overall Excellent Resouces. I have attached a sample data for the reference</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Need help https://community.qlik.com/t5/QlikView/Need-help/m-p/1349767#M820502 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>My requirement is as below</P><P></P><P>I have a review done by for each resources by Internal and External for few categoires. The resources are rated based on each Category on a scale of 1 to 10. if rating value is NA which means the resource has not been rated for that category and should not be considerd for calculation. For example Name1 has been rated for 3 Categories</P><P></P><P>Condition 1: The resources would be considered as <STRONG>Excellent</STRONG> by Internal if only rating for all the categories for which he is rated is &gt;7</P><P>Condition 2: <SPAN style="font-size: 13.3333px;">The resources would be considered as </SPAN><SPAN style="font-size: 13.3333px;"><STRONG>Excellent</STRONG></SPAN><SPAN style="font-size: 13.3333px;"> by External if only rating for all the categories for which he is rated is &gt;7</SPAN></P><P></P><P>If the resource is EXCELLENT in both Internal and Extrenal over all valid Categories , Then the resource will be considered as <STRONG>Overall Excellent</STRONG></P><P></P><P>I just want to create a chart which will tell me total no of resources and how many of them has <STRONG>overall as Excellent . The chart should have 3 columns</STRONG></P><P></P><P>Any dimension , Total No of Resources for that dimension and Total no of Overall Excellent Resouces. I have attached a sample data for the reference</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/1349767#M820502 2020-11-25T16:16:04Z Re: Need help https://community.qlik.com/t5/QlikView/Need-help/m-p/1349768#M820503 <HTML><HEAD></HEAD><BODY><P>May be like this?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/172512_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Fri, 04 Aug 2017 12:11:12 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/1349768#M820503 sunny_talwar 2017-08-04T12:11:12Z