Discussion Board for collaboration related to QlikView App Development.
please suggest on below scenario and provide any possible solution
we have to compare the key field from one table (Dimension table) to two separate fields in another table (Fact table).
how to compare key field to fetch the Full name column details ?
Hi @srinivas1921 ,
If I understand you correctly, you want to associate your dimension table with your fact table anywhere CD_Loc is equal to either END_Loc1 or END_Loc2. Is that correct?
If so I believe you can concatenate the table twice and duplicate records to do this (please be careful when aggregating on this table). You can do this by trying something like this.
End_Loc2 as End_Loc1,
I hope this makes sense, please let me know if I've misunderstood your question.
It looked that you could apply an IntervalMatch.