topic Check_verify_values month to month in QlikView https://community.qlik.com/t5/QlikView/Check-verify-values-month-to-month/m-p/1133353#M372360 <HTML><HEAD></HEAD><BODY><P>Hello guys!</P><P></P><P>I dont know how to calculate:</P><UL><LI>Fires</LI><LI>New Hires</LI></UL><P></P><P>I have 2 tables (A &amp; B)</P><P></P><P><STRONG>Table A (People and Projects)</STRONG></P><P><STRONG>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Project</STRONG></P><P>AA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; alfa</P><P>BB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Beta</P><P>CC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Gamma</P><P>DD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Epsilon&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P><STRONG>Table B (Date and Project)</STRONG></P><P style="font-size: 13.3333px;"><STRONG>&nbsp; Date&nbsp;&nbsp;&nbsp; Project</STRONG></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alfa</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Beta</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Gamma</SPAN></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alfa</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Beta</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp; Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Epsilon</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">I would like to Know the new <STRONG>hires</STRONG> and the <STRONG>fires&nbsp; </STRONG>for each month</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">So in <STRONG>february</STRONG> the guy " CC" doesnt work and the guy "DD" is the new hire in the team (1 hire + 1 fire)</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">I would like to grapgh the hires and the fires due to are the same people working in both months but are different people</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Help me please!!!!<BR /></SPAN></P></BODY></HTML> Tue, 28 Jun 2016 15:19:35 GMT 2016-06-28T15:19:35Z Check_verify_values month to month https://community.qlik.com/t5/QlikView/Check-verify-values-month-to-month/m-p/1133353#M372360 <HTML><HEAD></HEAD><BODY><P>Hello guys!</P><P></P><P>I dont know how to calculate:</P><UL><LI>Fires</LI><LI>New Hires</LI></UL><P></P><P>I have 2 tables (A &amp; B)</P><P></P><P><STRONG>Table A (People and Projects)</STRONG></P><P><STRONG>ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Project</STRONG></P><P>AA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; alfa</P><P>BB&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Beta</P><P>CC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Gamma</P><P>DD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Epsilon&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P><STRONG>Table B (Date and Project)</STRONG></P><P style="font-size: 13.3333px;"><STRONG>&nbsp; Date&nbsp;&nbsp;&nbsp; Project</STRONG></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alfa</P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Beta</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Jan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Gamma</SPAN></P><P style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alfa</P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp; Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Beta</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp; Feb&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Epsilon</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">I would like to Know the new <STRONG>hires</STRONG> and the <STRONG>fires&nbsp; </STRONG>for each month</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">So in <STRONG>february</STRONG> the guy " CC" doesnt work and the guy "DD" is the new hire in the team (1 hire + 1 fire)</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">I would like to grapgh the hires and the fires due to are the same people working in both months but are different people</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">Help me please!!!!<BR /></SPAN></P></BODY></HTML> Tue, 28 Jun 2016 15:19:35 GMT https://community.qlik.com/t5/QlikView/Check-verify-values-month-to-month/m-p/1133353#M372360 2016-06-28T15:19:35Z