Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sanjay006
Contributor

Union of two fields without concatenation

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

3 Replies
passionate
Valued Contributor

Re: Union of two fields without concatenation

Hi Sanjay,

Please post some sample data.

Regards,

Pankaj

sanjay006
Contributor

Re: Union of two fields without concatenation

​PFA,

Thans in advance​

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

passionate
Valued Contributor

Re: Union of two fields without concatenation

Try using link table for now.

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

Community Browser