topic Re: budget vs sales in QlikView

budget vs sales

Anonymous — Mon, 02 Nov 2015 13:45:36 GMT

I have the following design

Budget :

load

"Code Site"&"Code Structure"&Comp&"Date Time" as BudgetId,

summonth,

sumyear

;

SQL SELECT "Code Site",

"Code Structure",

Comp,

"Date Time",

summonth,

sumyear

FROM QlikDataWarehouse.dbo."V_Budget";

But I didn't get the best result , how to resolve it ?

Re: budget vs sales

Mark_Little — Mon, 02 Nov 2015 13:54:31 GMT

Hi,

Could you please supply a little more information?

What are the issues you are seeing?

From the above I am assuming the table TempVente is your fact table, ideally for the budget values to be driven by the calendar I would be looking to concatenate the budget table to the fact table.

Mark

Re: budget vs sales

rubenmarin — Mon, 02 Nov 2015 13:57:29 GMT

Hi, I would check that the BudgetId values loaded in Budget has a similar value in TempVente tables.

For that I'll create a field BudgetId_Budget in Budget table and a BudgetId_Vente in TempVente tables.

With a table box with BudgetId, BudgetId_Budget and BudgetId_Vente you can check if all columns have a related value or there are something differnt (just guessing but most probably caused by different dates format, maybe one is datetime and the other only date)

Re: budget vs sales

jafari_ervin — Mon, 02 Nov 2015 14:00:11 GMT

what do you mean you didn't get the best result. Please explain more and send sample document.