topic Re: Link Budget Table. in QlikView

Link Budget Table.

ch_riadh — Mon, 20 Jun 2016 23:49:34 GMT

hello guys,

I have

-Sales table.

Fields:

Vehicle_Model

MonthYear ' invoiceDate '

Sale_Amount

-Budget table:

Fields:

Vehicle_Model

MonthYear ' BudgetDate'

Budget_Amount

I want to compare the Budget & Sale Amount (Line Chart)

What i did:

Create a Key ( Vehicle_Model &'-'& MonthYear ) , it is look good, but the Budget value are not matching.

Solution : when i use only one field (Model or MonthYear) to link the 2 table, the Value become Correct.

But i need Both Dimension.

Thanks

Re: Link Budget Table.

sunny_talwar — Mon, 20 Jun 2016 23:51:58 GMT

Can you share the application or the script you are currently using?

Re: Link Budget Table.

Tue, 21 Jun 2016 05:05:15 GMT

I suggest you should concatenate those 2 tables & have 2 different types as a column for Sales & Budget

With that you can have 1 MonthYear column that you can use to generate calendar

Sales table.

Fields:

Vehicle_Model

MonthYear

Sale_Amount As Amount

'Sales' As Type

//concatenate -Budget table:

Fields:

Vehicle_Model

MonthYear

Budget_Amount As Amount

'Budget' As Type

Re: Link Budget Table.

Digvijay_Singh — Tue, 21 Jun 2016 05:14:45 GMT

You may try joining them in case your both sales and budget are at same level of granularity, i.e. MonthYear. Against same month year and Vehicle_Model you will have sales and budget in the same row. But if Budget is at year level and sales at month level then it would be better to concatenate and create record type 'Sales' or 'Budget' to identify them in the same table.

Re: Link Budget Table.

sujeetsingh — Tue, 21 Jun 2016 05:19:43 GMT

Can you please come in more words that what statstics you want to show in your application.