topic Latest date per employee per indicator in QlikView https://community.qlik.com/t5/QlikView/Latest-date-per-employee-per-indicator/m-p/297520#M708092 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>Trying to make an overview for holidays per employee. Running into the following problem:</P><P></P><P>Regulations are in the sp_indicator table but different per employee. The valid from date differs as users may be later on the payroll than start of the year.</P><P>As I try to make a list of remaining holidays from last year or holidays for contractual rights the indicator type is different from the indicator_type_id field. To get the correct data I used the If statement in the overview table... however, I need a latest date per employee for each indicator type. </P><P></P><P>How can I do this?</P><P></P><P>Best regards,</P><P></P><P>Marco</P><P></P><P><IMG alt="Holiday overview.png" class="jive-image-thumbnail jive-image" height="386" onclick="" src="https://community.qlik.com/legacyfs/online/7613_Holiday+overview.png" width="659" /></P></BODY></HTML> Wed, 28 Sep 2011 15:01:34 GMT 2011-09-28T15:01:34Z Latest date per employee per indicator https://community.qlik.com/t5/QlikView/Latest-date-per-employee-per-indicator/m-p/297520#M708092 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>Trying to make an overview for holidays per employee. Running into the following problem:</P><P></P><P>Regulations are in the sp_indicator table but different per employee. The valid from date differs as users may be later on the payroll than start of the year.</P><P>As I try to make a list of remaining holidays from last year or holidays for contractual rights the indicator type is different from the indicator_type_id field. To get the correct data I used the If statement in the overview table... however, I need a latest date per employee for each indicator type. </P><P></P><P>How can I do this?</P><P></P><P>Best regards,</P><P></P><P>Marco</P><P></P><P><IMG alt="Holiday overview.png" class="jive-image-thumbnail jive-image" height="386" onclick="" src="https://community.qlik.com/legacyfs/online/7613_Holiday+overview.png" width="659" /></P></BODY></HTML> Wed, 28 Sep 2011 15:01:34 GMT https://community.qlik.com/t5/QlikView/Latest-date-per-employee-per-indicator/m-p/297520#M708092 2011-09-28T15:01:34Z Latest date per employee per indicator https://community.qlik.com/t5/QlikView/Latest-date-per-employee-per-indicator/m-p/297521#M708093 <HTML><HEAD></HEAD><BODY><P><EM>Hi Marco,</EM></P><P></P><P><EM>Sorry, this is confusing. Please can you post the QV document?</EM></P><P></P><P><EM>Thanks - DV</EM></P></BODY></HTML> Thu, 29 Sep 2011 10:44:56 GMT https://community.qlik.com/t5/QlikView/Latest-date-per-employee-per-indicator/m-p/297521#M708093 IAMDV 2011-09-29T10:44:56Z Re: Latest date per employee per indicator https://community.qlik.com/t5/QlikView/Latest-date-per-employee-per-indicator/m-p/297522#M708094 <HTML><HEAD></HEAD><BODY><P>No probleem.. please find attached.</P><P></P><P>All test data but scrambled it anyway... thanks.</P><P></P><P></P><P>Best regards,</P><P></P><P>Marco</P></BODY></HTML> Thu, 29 Sep 2011 10:58:47 GMT https://community.qlik.com/t5/QlikView/Latest-date-per-employee-per-indicator/m-p/297522#M708094 2011-09-29T10:58:47Z Latest date per employee per indicator https://community.qlik.com/t5/QlikView/Latest-date-per-employee-per-indicator/m-p/297523#M708095 <HTML><HEAD></HEAD><BODY><P><STRONG>Well I hope this is all fake test data.</STRONG> <EM>Otherwise you just posted some personal data. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/alert.png" /></EM></P><P></P><P>Use the scramble option (Document Properties - Scrambling) to scramble personal data (like names).</P></BODY></HTML> Thu, 29 Sep 2011 11:41:31 GMT https://community.qlik.com/t5/QlikView/Latest-date-per-employee-per-indicator/m-p/297523#M708095 Michiel_QV_Fan 2011-09-29T11:41:31Z