topic Re: Model not displaying Budget figures in QlikView

Model not displaying Budget figures

Thu, 23 Mar 2017 13:16:21 GMT

Hi All,

PFA

I have created a model which has 4 fact tables and few dimensions, I have used generic keys to join fact tables but it does not show me Budget and Sales figures side by side.

Please assist.

Thanks

Re: Model not displaying Budget figures

sunny_talwar — Thu, 23 Mar 2017 13:22:44 GMT

What is your dimension here? The only thing common between Budget and Sales is StockCode, TrnMonth, & TrnYear... If you have those as your dimension.... things will work as Sum(Budget) and Sum(Sales)... since nothing else is common, other dimensions may or may not work...

Re: Model not displaying Budget figures

Thu, 23 Mar 2017 13:28:05 GMT

Hi Sunny,

Diemnsions :

Products

Customer

Area,

Branch,

and the four fact tables

Re: Model not displaying Budget figures

vinieme12 — Thu, 23 Mar 2017 13:37:30 GMT

it's because your %Bdid isn't associated with your %said

You need to revise how you are creating the link table

Re: Model not displaying Budget figures

sunny_talwar — Thu, 23 Mar 2017 13:37:48 GMT

May be like attached

Left Join Budget into Sales table

Re: Model not displaying Budget figures

Thu, 23 Mar 2017 13:50:47 GMT

Ok thanks for the response, it looks fine but I can also concatenate them?

Re: Model not displaying Budget figures

sunny_talwar — Thu, 23 Mar 2017 13:52:35 GMT

LinkTable might work... but will have to link them on the StockCode, TrnYear and TrnMonth....