Discussion Board for collaboration on QlikView Scripting.
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.
I didn't your exact requirement...can you please elaborate bit more
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.
check this attachment :
hope this helps you
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...
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?
can you share your script ??
Plz find attachment.