Default Time stamp from Excel to load in Variables
Hi Friends can anyone please do needful help on Latest Data Time stamp need to be Loaded into QlikView
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 Latest Source Date has yyyymm format.
But my problem is without loading into separately 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 Month,year,Quarter by using single dimension.
