Union of two fields without concatenation

[sanjay006]

Hello all,

I m stuck in one scenario please help me out !

I have one fact table one budget table and one actual table.Budget is changing for every financial year but actual will remain same.Now i have to link my fact to these table as such I get the union result of both actual and budget table and budget should be change accordingly as per the financial year.

Note : I can't concate my fact with these two table i only can link by the composite key which is

org_Id&Item_code&F.Y   (Key between fact and budget)

ord_Id_Item_Code&Component_Item (Key between actual and budget)

Any kind of help is appreciated.

Thanks in advance

[passionate]

Hi Sanjay,

Please post some sample data.

Regards,

Pankaj

[sanjay006]

​PFA,

Thans in advance​

On Fri, Sep 15, 2017 at 9:24 PM, Pankaj Thakur <qcwebmaster@qlikview.com>

[passionate]

Try using link table for now.

But, if you have a ETL before qlikview try to implement dimensional modeling to solve your issue.