topic Two dates in the same table in QlikView https://community.qlik.com/t5/QlikView/Two-dates-in-the-same-table/m-p/335365#M123664 <HTML><HEAD></HEAD><BODY><P>In my table I have two dates( date 1, date2 ), sometimes I have o calc a column using date 1 and sometimes I have to use the date 2. For the selection I would have just one date for reference.</P><P></P><P>Date 1 = ADMISSÃO, Date 2 DEMISSÃO</P><P></P><P>Example 1 : =count({$&lt;ANO_DEMISSÃO={"=[ANO_ADMISSÃO]"}, MES_DEMISSÃO={"=[MES_ADMISSÃO]"}&gt;}&nbsp; RA_MAT) </P><P></P><P>In the&nbsp; Example 1 i have the Year and the month of date1 selected and the column must be show the values the year and month the date2.</P><P>One selection for reference two dates in the same table for different calculus </P></BODY></HTML> Tue, 03 Apr 2012 18:29:32 GMT 2012-04-03T18:29:32Z Two dates in the same table https://community.qlik.com/t5/QlikView/Two-dates-in-the-same-table/m-p/335365#M123664 <HTML><HEAD></HEAD><BODY><P>In my table I have two dates( date 1, date2 ), sometimes I have o calc a column using date 1 and sometimes I have to use the date 2. For the selection I would have just one date for reference.</P><P></P><P>Date 1 = ADMISSÃO, Date 2 DEMISSÃO</P><P></P><P>Example 1 : =count({$&lt;ANO_DEMISSÃO={"=[ANO_ADMISSÃO]"}, MES_DEMISSÃO={"=[MES_ADMISSÃO]"}&gt;}&nbsp; RA_MAT) </P><P></P><P>In the&nbsp; Example 1 i have the Year and the month of date1 selected and the column must be show the values the year and month the date2.</P><P>One selection for reference two dates in the same table for different calculus </P></BODY></HTML> Tue, 03 Apr 2012 18:29:32 GMT https://community.qlik.com/t5/QlikView/Two-dates-in-the-same-table/m-p/335365#M123664 2012-04-03T18:29:32Z