topic Bar chart set analysis in QlikView https://community.qlik.com/t5/QlikView/Bar-chart-set-analysis/m-p/341022#M573714 <HTML><HEAD></HEAD><BODY><P>I need to make a bar chart to compare how many hours a certain group are inputting into a tracker. Then next to that groups bar, put the amount of hours they should be putting in, assuming each person within the group works 40 hours a week.</P><P></P><P>So I need to find out how many unique 'Tech ID' there are (so I can see how many people there are because I dont have an exact list) and then group them by their 'Tech Group'&nbsp; field, add up how many hours they have inputted and compare that to a bar next to it with the amount of hours they should have put in.</P><P></P><P>Thanks! </P></BODY></HTML> Mon, 09 Jul 2012 13:15:48 GMT 2012-07-09T13:15:48Z Bar chart set analysis https://community.qlik.com/t5/QlikView/Bar-chart-set-analysis/m-p/341022#M573714 <HTML><HEAD></HEAD><BODY><P>I need to make a bar chart to compare how many hours a certain group are inputting into a tracker. Then next to that groups bar, put the amount of hours they should be putting in, assuming each person within the group works 40 hours a week.</P><P></P><P>So I need to find out how many unique 'Tech ID' there are (so I can see how many people there are because I dont have an exact list) and then group them by their 'Tech Group'&nbsp; field, add up how many hours they have inputted and compare that to a bar next to it with the amount of hours they should have put in.</P><P></P><P>Thanks! </P></BODY></HTML> Mon, 09 Jul 2012 13:15:48 GMT https://community.qlik.com/t5/QlikView/Bar-chart-set-analysis/m-p/341022#M573714 2012-07-09T13:15:48Z Re: Bar chart set analysis https://community.qlik.com/t5/QlikView/Bar-chart-set-analysis/m-p/341023#M573715 <HTML><HEAD></HEAD><BODY><P>Or should I make this other variable in the script?</P><P></P><P>Anyway to do this is fine with me as long as I can compare the total time reported by each 'Tech Group' to how much they should be reporting based on how many unique 'Tech ID' there is in each 'Tech Group'.</P><P></P><P>Tech group and tech ID are both characters, not numbers.</P></BODY></HTML> Mon, 09 Jul 2012 13:36:15 GMT https://community.qlik.com/t5/QlikView/Bar-chart-set-analysis/m-p/341023#M573715 2012-07-09T13:36:15Z Re: Bar chart set analysis https://community.qlik.com/t5/QlikView/Bar-chart-set-analysis/m-p/341024#M573716 <HTML><HEAD></HEAD><BODY><P>Anyone know how to go about doing this?</P></BODY></HTML> Mon, 09 Jul 2012 14:41:37 GMT https://community.qlik.com/t5/QlikView/Bar-chart-set-analysis/m-p/341024#M573716 2012-07-09T14:41:37Z