Discussion board where members can get started with Qlik Sense.
I have sales and Inventory tables.
I have concatenated both the fact tables and It is perfectly fine but the only thing is when i link Customer Dim table to fact table then I am getting Measure(Inventory) whcih shd be zero.
Can you help me out how I can proceed in resolving this Issue?
Go to Solution.
concatenate two tables
but add flags in both the tables to get correct result in front end
0 as Flag
from sql ;
1 as flag
we need to have some more details about your Data Model.
so can you attached sample file with your existing Data Model
I did that but My question is how to connect Customer Table to only sales fact table and not with the Inventory.
I just removed the Null values were creating the problem.
Thanks for your help.