topic Group by in Set analysis in QlikView https://community.qlik.com/t5/QlikView/Group-by-in-Set-analysis/m-p/1244535#M394811 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have data something like this</P><P></P><TABLE><TBODY><TR><TD>Employee</TD><TD>Company</TD><TD>DateOfJoining</TD><TD>LastWorkingDay</TD></TR><TR><TD>Keerthi</TD><TD>Business Solutions Pvt Ltd</TD><TD>2008-12-01 00:00:00.000</TD><TD>2015-12-17 00:00:00.000</TD></TR><TR><TD>Keerthi</TD><TD>Objects Pvt Ltd</TD><TD>2005-05-18 00:00:00.000</TD><TD>2008-11-28 00:00:00.000</TD></TR><TR><TD>Deepak</TD><TD>Consulting Pvt Ltd</TD><TD>2002-11-04 00:00:00.000</TD><TD>2005-02-25 00:00:00.000</TD></TR><TR><TD>Deepak</TD><TD>Network</TD><TD>2002-01-23 00:00:00.000</TD><TD>2002-10-23 00:00:00.000</TD></TR></TBODY></TABLE><P></P><P></P><P>I want to calculate the total experience.</P><P></P><P>Ex: For Keerthi Total Experience will be</P><P></P><P>Interval(<SPAN style="font-size: 13.3333px;">2008-11-28 00:00:00.000,<SPAN style="font-size: 13.3333px;">2005-05-18 00:00:00.000</SPAN></SPAN>) + <SPAN style="font-size: 13.3333px;"> Interval(<SPAN style="font-size: 13.3333px;">2015-12-17 00:00:00.000</SPAN></SPAN><SPAN style="font-size: 13.3333px;">,<SPAN style="font-size: 13.3333px;">2008-12-01 00:00:00.000</SPAN></SPAN><SPAN style="font-size: 13.3333px;">) </SPAN></P><P></P><P>How do i do it in Qlikview using set analysis.</P><P></P><P></P><P>Regards,</P><P>Keerthi KS</P></BODY></HTML> Mon, 14 Nov 2016 10:06:35 GMT 2016-11-14T10:06:35Z Group by in Set analysis https://community.qlik.com/t5/QlikView/Group-by-in-Set-analysis/m-p/1244535#M394811 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I have data something like this</P><P></P><TABLE><TBODY><TR><TD>Employee</TD><TD>Company</TD><TD>DateOfJoining</TD><TD>LastWorkingDay</TD></TR><TR><TD>Keerthi</TD><TD>Business Solutions Pvt Ltd</TD><TD>2008-12-01 00:00:00.000</TD><TD>2015-12-17 00:00:00.000</TD></TR><TR><TD>Keerthi</TD><TD>Objects Pvt Ltd</TD><TD>2005-05-18 00:00:00.000</TD><TD>2008-11-28 00:00:00.000</TD></TR><TR><TD>Deepak</TD><TD>Consulting Pvt Ltd</TD><TD>2002-11-04 00:00:00.000</TD><TD>2005-02-25 00:00:00.000</TD></TR><TR><TD>Deepak</TD><TD>Network</TD><TD>2002-01-23 00:00:00.000</TD><TD>2002-10-23 00:00:00.000</TD></TR></TBODY></TABLE><P></P><P></P><P>I want to calculate the total experience.</P><P></P><P>Ex: For Keerthi Total Experience will be</P><P></P><P>Interval(<SPAN style="font-size: 13.3333px;">2008-11-28 00:00:00.000,<SPAN style="font-size: 13.3333px;">2005-05-18 00:00:00.000</SPAN></SPAN>) + <SPAN style="font-size: 13.3333px;"> Interval(<SPAN style="font-size: 13.3333px;">2015-12-17 00:00:00.000</SPAN></SPAN><SPAN style="font-size: 13.3333px;">,<SPAN style="font-size: 13.3333px;">2008-12-01 00:00:00.000</SPAN></SPAN><SPAN style="font-size: 13.3333px;">) </SPAN></P><P></P><P>How do i do it in Qlikview using set analysis.</P><P></P><P></P><P>Regards,</P><P>Keerthi KS</P></BODY></HTML> Mon, 14 Nov 2016 10:06:35 GMT https://community.qlik.com/t5/QlikView/Group-by-in-Set-analysis/m-p/1244535#M394811 2016-11-14T10:06:35Z Re: Group by in Set analysis https://community.qlik.com/t5/QlikView/Group-by-in-Set-analysis/m-p/1244536#M394812 <HTML><HEAD></HEAD><BODY><P>calculate interval for each company in years or months and then use sum for that field.</P><P></P><P>to calculate interval in month refer <A href="https://community.qlik.com/thread/47580">How Do I Get the Number of Months Between Two Dates?</A></P></BODY></HTML> Mon, 14 Nov 2016 10:11:34 GMT https://community.qlik.com/t5/QlikView/Group-by-in-Set-analysis/m-p/1244536#M394812 shraddha_g 2016-11-14T10:11:34Z Re: Group by in Set analysis https://community.qlik.com/t5/QlikView/Group-by-in-Set-analysis/m-p/1244537#M394813 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>see Attachment.</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143818_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Regards,</P><P>Antonio</P></BODY></HTML> Mon, 14 Nov 2016 10:32:20 GMT https://community.qlik.com/t5/QlikView/Group-by-in-Set-analysis/m-p/1244537#M394813 antoniotiman 2016-11-14T10:32:20Z