Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Actual Sales vs Sales Budget

Hi guys

I have a QV Sales model & I also have a Sales Budget that was done in Excel. I don't know how to add the budget to this model without having loops etc.

I am attaching the table viewer that shows the Sales QV Model as it is at the moment. You will also see that there is a seperate Budget table in the table viewer (this is the excel file I mentioned). I have added "%" infront of every field so that it do not create loops etc.

I need to link that budget to the indicated fields if possible.

If someone could advise I would appreciate it alot.

5 Replies
sparur
Valued Contributor II

Actual Sales vs Sales Budget

Hello

I advice you to join budgetAmount into your Sales table. So you no need to change model

Highlighted
Not applicable

Actual Sales vs Sales Budget

Thanks for the reply. So you say I must join BudgetSalesAmount into my INVOICE table. What join will I be using?

Regads

sparur
Valued Contributor II

Actual Sales vs Sales Budget

I tnink

LEFT JOIN(INVOICE)

LOAD

....

RESIDENT Budget;

Not applicable

Actual Sales vs Sales Budget

On what field will this then join as there is no field that is the same?

sparur
Valued Contributor II

Actual Sales vs Sales Budget

no same fields ? that's strange. Usually, the main task is comparing budget and Sales amount.

so you should have several same fields, for example: TransDate, Customer, Item etc...