topic Default Time stamp from Excel to load in Variables in QlikView https://community.qlik.com/t5/QlikView/Default-Time-stamp-from-Excel-to-load-in-Variables/m-p/785176#M277849 <HTML><HEAD></HEAD><BODY><P>Hi Friends can anyone please do needful help on Latest Data Time stamp need to be Loaded into QlikView</P><P>My problem is each month Users will give data in Excel Files and in Separate sheet they will give Time stamp(this time stamp column gives what is the latest source data )of in a single column <STRONG style="text-decoration: underline;">Latest Source Date </STRONG>has yyyymm format.</P><P>But my problem is without loading into separately&nbsp;&nbsp; in QlikView is there any way to use this Column in QlikView. If there is no possibilities in such case any variable can hold this value and need to use in the Design.Based on Time stamp (YYYYMM ) need to get&nbsp; Month,year,Quarter by using single dimension.</P><P>Hoping a solution on this.....</P><P>Thanks</P></BODY></HTML> Wed, 25 Mar 2015 05:41:44 GMT Anonymous 2015-03-25T05:41:44Z Default Time stamp from Excel to load in Variables https://community.qlik.com/t5/QlikView/Default-Time-stamp-from-Excel-to-load-in-Variables/m-p/785176#M277849 <HTML><HEAD></HEAD><BODY><P>Hi Friends can anyone please do needful help on Latest Data Time stamp need to be Loaded into QlikView</P><P>My problem is each month Users will give data in Excel Files and in Separate sheet they will give Time stamp(this time stamp column gives what is the latest source data )of in a single column <STRONG style="text-decoration: underline;">Latest Source Date </STRONG>has yyyymm format.</P><P>But my problem is without loading into separately&nbsp;&nbsp; in QlikView is there any way to use this Column in QlikView. If there is no possibilities in such case any variable can hold this value and need to use in the Design.Based on Time stamp (YYYYMM ) need to get&nbsp; Month,year,Quarter by using single dimension.</P><P>Hoping a solution on this.....</P><P>Thanks</P></BODY></HTML> Wed, 25 Mar 2015 05:41:44 GMT https://community.qlik.com/t5/QlikView/Default-Time-stamp-from-Excel-to-load-in-Variables/m-p/785176#M277849 Anonymous 2015-03-25T05:41:44Z Re: Default Time stamp from Excel to load in Variables https://community.qlik.com/t5/QlikView/Default-Time-stamp-from-Excel-to-load-in-Variables/m-p/785177#M277850 <HTML><HEAD></HEAD><BODY><P>Attaching sample any help on this</P></BODY></HTML> Thu, 26 Mar 2015 05:11:31 GMT https://community.qlik.com/t5/QlikView/Default-Time-stamp-from-Excel-to-load-in-Variables/m-p/785177#M277850 Anonymous 2015-03-26T05:11:31Z