topic Re: Linking two tables - data missing in QlikView

Linking two tables - data missing

Hoowling — Sat, 16 Nov 2024 03:02:16 GMT

Hi community,

I am new to qlikview and need help with an issue that I have been struggling with.
I want to link two tables containing actual and budgeted sales for a given period, product family, business unit and currency.

I created a key based on these dimensions between the actual and budget tables and expected to get the result indicated below. The problem is that since no items where sold of the bottom two rows in the expected results table (indicated in red) those keys are not created (i.e. they don't exist), so the budget numbers have nothing to match against.

The result is that the budget figures in red below does not appear in the resulting table and the total budget is to low - 390 instead of 595...
Any suggestions on can structure the script so that data for unsold but budgeted sales is presented?

P.s. except for the key, the dimensions between the actual and budget tables does not share name - i.e. no synthetic keys are created (by using qualify * on the budget table).

//Hoowling

Re: Linking two tables - data missing

Vegar — Thu, 11 Jul 2019 07:52:13 GMT

Hence you are qualifying the budget dimensions you do not have any association to your BU, Currency, Product or YearMonth for your missing rows.

Consider the alternative solution, concatenating the data into one single table.

Re: Linking two tables - data missing

Vegar — Thu, 11 Jul 2019 08:03:46 GMT

I've made a sample for you.

PS In the future when posting questions like this, please attach data sample as text/excel/qvw and not as picture. It will be much easier for the community to help with an relevant example when the data is easily available. DS

Re: Linking two tables - data missing

Hoowling — Thu, 11 Jul 2019 09:18:24 GMT

Worked perfectly, thanks!

Will make sure to attach data for future questions.

//Hoowling