Issue with Date field during concatenation

canoebi99 — Thu, 14 Jun 2012 21:12:29 GMT

Hi all, I am pretty new to Qlikview so please be gentle with me!

I have loaded in to a pre existing template some monthly sales budgets and against them have allocated a myDate field of the 1st of each month.

Once loaded in to a table I am then concatenating them into the main transactions table which also has a myDate field.

My issue is that when I do the concatenation I lose all the dates that are against all the other transactions in the main transaction table. The sales target info loads in fine and has a date against it but all the other transactions then show a "-" in the myDate field.

From what I have read I am guessing it is something to do with the date format but I have tried every which way and can't solve it.

Can someone please explain how qlikview handles dates re formatting and concatenating tables together?

if it helps to know we have a statement at the beginning of the document that is SET DateFormat = 'D/MM/YYYY';

Any advice in this area would be gratefully received because I have spent hours trying to resolve this.

Many thanks

Ben

topic Issue with Date field during concatenation in QlikView

Issue with Date field during concatenation