Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
Worked perfectly, thanks!
Will make sure to attach data for future questions.
//Hoowling