Data Model: Question

[qlikviewaf]

Hi,

i created my data model which is based on the sales-table where i have the full list of sales order with related amount etc.

On my data model there's also the calendar which is linked to the invoice date of the sales-order.

Now i would like to add the budget where the dimension are: year - month - region

The region is an attribute of the customer (on sales table).

How i should create the link between the budget table and my data model? I'm a little bit confused

Thanks

[CarlosAMonroy]

Just add MonthEnd() to the Date field, something like:

MonthEnd(makedate(rigth(YearMonth,4),if(left(YearMonth,3)='Jan',1,if(left(YearMonth,3)='Feb',2,if(left(YearMonth,3)='Mar',3,if(left(YearMonth,3)='Apr',4,if(left(YearMonth,3)='May',5,if(left(YearMonth,3)='Jun',6,if(left(YearMonth,3)='Jul',7,if(left(YearMonth,3)='Aug',8,if(left(YearMonth,3)='Sep',9,if(left(YearMonth,3)='Oct',10,if(left(YearMonth,3)='Nov',11,if(left(YearMonth,3)='Dec',12))))))))))))) as Date