I have a question/problem. I designed a Qlikview Document SalesInvoice. In the script of dis document the FactTables SalesInvoice is loaded. There is a LineAmount which is used for the Actual Invoices (LineNumber 00) and Budget (LineNumber 01,02….,12) So we have in our Table twelve records related to Months and Amounts.
With the IF-statement I split Line-Amount into BudgetAmount and ActualAmount. Now my chef want a view (Graphic or Table) with Week and Day amount for Actual and Budget. The ActualAmounts are not the problem because they have different Postingdates. The BudgetAmounts have only one date (the first day) of the month.
Other problems are:
the Amounts per Month are not equal, in summer the amounts are bigger as in winter.
Not every day has an amount, the DayAmount shouldbe calculated à BudgetAmount divided by 21, The WeekAmount is then (BudgetAmount divided by 21) multiply with 5.
Question is now can I give my chef his view, so recalculate budget into days and how should I do that. Within the SalesInvoice load, create a new table CalculationedAmounts based on the MasterCalendar, resident SalesInvoice or should I calculate it with the expressions in the Dashboards, I think I need also the Autogenerate-function but I’m not sure. What is the best solution, I prefer a solution in the script above a DashboardSolution