I am attaching excel sheet of target to data model with Master date.
When I concatenate, I gets the both date of Excel sheet and Master date as well.
But targets are not working with calender,
Say, I am having 01/Jan/2014 in Excel and same in Master date, If I selects 01/Jan/2014 of Excel sheet, I am getting tha data on excel sheet selection but not on master date.
I have tried all the Date formats but not getting the solution.
can you use this formula while loading in qlikview and try
Date(Num(Evaluate(Dates))) as Date,
Vikas
Hope this resolve your issue. If the issue is solved please mark the answer with Accept as Solution & like it. If you want to go quickly, go alone. If you want to go far, go together.
