Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
avinashelite

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

Not applicable
Author

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.

avinashelite

check this attachment :

hope this helps you

svenkita
Creator II
Creator II

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
Author

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?

avinashelite

can you share your script ??

Not applicable
Author

Hi Avinash,

Plz find attachment.