topic Identify DATE in another table in QlikView https://community.qlik.com/t5/QlikView/Identify-DATE-in-another-table/m-p/817543#M1025923 <HTML><HEAD></HEAD><BODY><P>Good morning gentlemen,</P><P>Some time ago I'm thinking of a solution to my problem and decided to show here ...</P><P>Let's see if anyone can help me , come on.</P><P></P><P>I have 2 two tables:</P><P></P><P>-CALENDARIO_TRABALHO</P><P>-LANCAMENTO_PONTO</P><P></P><P></P><P>In <SPAN style="font-size: 13.3333330154419px;">CALENDARIO_TRABALHO </SPAN>table I have all employees with its range of clearances / work follows in annex.</P><P>In the <SPAN style="font-size: 13.3333330154419px;">LANCAMENTO_PONTO </SPAN>table I have all clocking records , with the date and with the same CPF .</P><P></P><P></P><P>What I need , is that it identifies the CPF DEVELOPER in DATE CALENDARIO_TRABALHO table and try to identify the same date in LANCAMENTO_PONTO table, and add some field "Fault" .</P><P></P><P>NOTE: In the Calendar table when the date is marked '1' means CLEARANCE IN THE DAY .</P><P></P><P>I hope help.</P><P>Thank U.</P></BODY></HTML> Mon, 02 Mar 2015 20:34:39 GMT Anonymous 2015-03-02T20:34:39Z Identify DATE in another table https://community.qlik.com/t5/QlikView/Identify-DATE-in-another-table/m-p/817543#M1025923 <HTML><HEAD></HEAD><BODY><P>Good morning gentlemen,</P><P>Some time ago I'm thinking of a solution to my problem and decided to show here ...</P><P>Let's see if anyone can help me , come on.</P><P></P><P>I have 2 two tables:</P><P></P><P>-CALENDARIO_TRABALHO</P><P>-LANCAMENTO_PONTO</P><P></P><P></P><P>In <SPAN style="font-size: 13.3333330154419px;">CALENDARIO_TRABALHO </SPAN>table I have all employees with its range of clearances / work follows in annex.</P><P>In the <SPAN style="font-size: 13.3333330154419px;">LANCAMENTO_PONTO </SPAN>table I have all clocking records , with the date and with the same CPF .</P><P></P><P></P><P>What I need , is that it identifies the CPF DEVELOPER in DATE CALENDARIO_TRABALHO table and try to identify the same date in LANCAMENTO_PONTO table, and add some field "Fault" .</P><P></P><P>NOTE: In the Calendar table when the date is marked '1' means CLEARANCE IN THE DAY .</P><P></P><P>I hope help.</P><P>Thank U.</P></BODY></HTML> Mon, 02 Mar 2015 20:34:39 GMT https://community.qlik.com/t5/QlikView/Identify-DATE-in-another-table/m-p/817543#M1025923 Anonymous 2015-03-02T20:34:39Z Re: Identify DATE in another table https://community.qlik.com/t5/QlikView/Identify-DATE-in-another-table/m-p/817544#M1025924 <HTML><HEAD></HEAD><BODY><P>up</P></BODY></HTML> Tue, 03 Mar 2015 11:57:15 GMT https://community.qlik.com/t5/QlikView/Identify-DATE-in-another-table/m-p/817544#M1025924 Anonymous 2015-03-03T11:57:15Z