topic Flag creation for the dates in QlikView https://community.qlik.com/t5/QlikView/Flag-creation-for-the-dates/m-p/966701#M331270 <HTML><HEAD></HEAD><BODY><P><BR />I have Date Dimension like below for multiple years.But, I don't want all years into qlikview.</P><P></P><P><STRONG>How to create a flag and pull the date for Jan'13-Dec'13&nbsp; as current year and Jan'14-Dec'14 as previous year?? </STRONG></P><P></P><P>Date_key_ID,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FullDT</P><P></P><P>20120101 (YYYY-MM-DD)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012-01-01</P><P>20120102,</P><P>20120103,</P><P></P><P>...</P><P>20121230</P><P>20121231..</P><P></P><P>How to<STRONG> inner Join </STRONG>dates in<STRONG> Date </STRONG>dimension<STRONG> with Clm_recieve_DT in T_FCT table??</STRONG></P><P></P><P>Clm_recieve_DT </P><P>20120101,</P><P>20120102,</P><P>20120103,</P><P>...</P></BODY></HTML> Mon, 26 Oct 2015 22:39:31 GMT 2015-10-26T22:39:31Z Flag creation for the dates https://community.qlik.com/t5/QlikView/Flag-creation-for-the-dates/m-p/966701#M331270 <HTML><HEAD></HEAD><BODY><P><BR />I have Date Dimension like below for multiple years.But, I don't want all years into qlikview.</P><P></P><P><STRONG>How to create a flag and pull the date for Jan'13-Dec'13&nbsp; as current year and Jan'14-Dec'14 as previous year?? </STRONG></P><P></P><P>Date_key_ID,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FullDT</P><P></P><P>20120101 (YYYY-MM-DD)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2012-01-01</P><P>20120102,</P><P>20120103,</P><P></P><P>...</P><P>20121230</P><P>20121231..</P><P></P><P>How to<STRONG> inner Join </STRONG>dates in<STRONG> Date </STRONG>dimension<STRONG> with Clm_recieve_DT in T_FCT table??</STRONG></P><P></P><P>Clm_recieve_DT </P><P>20120101,</P><P>20120102,</P><P>20120103,</P><P>...</P></BODY></HTML> Mon, 26 Oct 2015 22:39:31 GMT https://community.qlik.com/t5/QlikView/Flag-creation-for-the-dates/m-p/966701#M331270 2015-10-26T22:39:31Z