Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Datamodel issue with 2 fact tables

Hi Frnz,

I need small favor from you.

I would like to map    FACT_RATIO_L4 ====> DIM_ACCOUNT through L4AMID

                                  FACT_RATIO_L2 ====> DIM_ACCOUNT through L2AMID

                                 FACT_RATIO_L4 ====> DIM_PRODUCT through PRODUCT

                                  FACT_RATIO_L2 ====> DIM_PRODUCT through PRODUCT

I tried concatnate two fact tables, but i am not getting exact values.

Please help me to find a best solution.

Please find the attached QVW.

        

7 Replies

Re: Datamodel issue with 2 fact tables

I didn't your exact requirement...can you please elaborate bit more

Not applicable

Re: Datamodel issue with 2 fact tables

Hi Avinash,

In Qvw, If I uncomment PRODUCT in FACT_RATIO_L2. I am Getting Circular Ref. I would like to merge 2 fact tables and links to as i mentioned above.

And 2 Fact tables have different data.

Re: Datamodel issue with 2 fact tables

check this attachment :

hope this helps you

svenkita
Contributor II

Re: Datamodel issue with 2 fact tables

the data in the qvw does not give much... it would be good if you could elaborate more on the requirements.

with your current data-model if you just change

FACT_RATIO_L2: statement to Concatenate(FACT_RATIO_L4) it should be concatenating both the facts, but this will give you a synthetic keys...


Not applicable

Re: Datamodel issue with 2 fact tables

Hi,

It is working. But in DIM_ACCOUNT, it is not taking remaining fields. I have 6 fileds in DIM_ACCOUNT.It is showing only " key". How can i get?

Re: Datamodel issue with 2 fact tables

can you share your script ??

Not applicable

Re: Datamodel issue with 2 fact tables

Hi Avinash,

Plz find attachment.

Community Browser