Discussion Board for collaboration on QlikView Scripting.
I need to make a comparison between the actual sales and the sales budget.
in the Budget tab I createda calculated field: Month(budgetMont) as Budget_Month it dosnt work from some rason.
And the second field I created is key field : BudgetYear&'-'&Budget_Month&'-'&CategoryID as KeyCompare .
The goal is to link the budget table and the sales table.-
In Sales tab I created: Year&'-'&Month&'-'&CategoryID as KeyCompare
I created twice, once in sales table and once in SalesHistoty table.
What is the problem? whay it dosnt work?
Also, how can I create a calculated field in sales tab?
Example: QTY * COST
1) Month(budgetMont) as Budget_Month, Month function requires a date, you´re using a string "Jan", "Feb"
2) BudgetYear&'-'&Budget_Month&'-'&CategoryID I´d like to see you data Budget.xls
3) Year&'-'&Month&'-'&CategoryID as KeyCompare, I don´t see a field called Month and Year, maybe you´re talking about Month(Date), Year(Date)