Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Model not displaying Budget figures

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

1 Solution

Accepted Solutions

Re: Model not displaying Budget figures

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

6 Replies

Re: Model not displaying Budget figures

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...

Not applicable

Re: Model not displaying Budget figures

Hi Sunny,

Diemnsions :

Products

Customer 

Area,

Branch,

and the four fact tables

vinieme12
Esteemed Contributor II

Re: Model not displaying Budget figures

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

May be like attached

Left Join Budget into Sales table

Not applicable

Re: Model not displaying Budget figures

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

Re: Model not displaying Budget figures

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

Community Browser