topic Help with data models in QlikView

Help with data models

Mon, 26 Jan 2026 18:19:17 GMT

Hello all, please your help, with my data model, I have a table of delivery of sales orders where is all the detail of what sold, a table of budget where the items seller, year, month and goal, My problem is that by showing the budget in a dynamic table are not being considered items that have not been sold. The sales order delivery table is the main table, attached picture of how the model is

Re: Help with data models

Anonymous — Sat, 12 Nov 2016 17:51:13 GMT

Can you explain with example ?

Re: Help with data models

vinieme12 — Sat, 12 Nov 2016 18:09:01 GMT

I think you want to show both Sales and Budget which is are currently in different tables on a common time dimension field Year,Month !

Is this correct? if yes, Read Canonical Date

Re: Help with data models

Fri, 25 Nov 2016 23:18:40 GMT

Hello, thanks for your help

i have a budget table with fields: CodeItem,CodeSalesman,Month, Year and budgetkg and a table sales with fields: CodeItem,CodeSalesman,Month,Year,Kgsold, CodeClient, etc. in this tables are the sales, mi problem for example is when a CodeItem was not sold, this not appear in my pivot table, oly show the budget for items solds but should to show all items

My dimensions are: CodeSalesMan, Year, Month,CodeItem

Expresion: Sum(BudgetKG)

Re: Help with data models

Fri, 25 Nov 2016 23:20:34 GMT

in addition to year and month, i have dimensions CodeSalesMan and CodeItem, can you explain me with a example canonical date