Discussion Board for collaboration related to QlikView App Development.
I have a one requirement about make a data model use the below requirements.
i have a two tables
Tabel1 Id variable having data like 'Ref_id','Mi_Ref'
id, Id variable having data like 'Ref_id'
there are other Tables has to join to these two tables now my question is how to join(in data model) table1 and Table2 where 'id' is not exists then Mi-Ref need to give the information in front end level or join to 'Mi_ref',obviously when id is exists then it will display all the related 'id' data in front side but i dont know how to show 'Mi_ref ' data when i select 'Mi_ref' because in the data model they are joined using 'Id's .i dont know does it make sense or not.
Please guide me how to solve this.
You could try using a link table using Vineeth's logic.
id as Table1ID,
Subfield (Table1ID, ',') as Table2ID
id as Table2ID,
Thanks for getting back to me , i will elaborate more my requirements i have a data model like below
so i want to join 'comtable' into my data model ,comtable contains combinations of values like 'RET100' and '111a' these are te information avaiable in different tables like 111a-AGTable and RET100-CTable.
So how do i join comtable into other table? if i join to Ctable i wouldn't get AGTable data
join to AGTable ,not able to get Ctable data in front end charts right,
how do i resolve this .
As per your logic if i create link table it will be forming circular reference right(it was my mistake didnt expalin clearly )
Well, I'm assuming it can't be both the A_ID,D_id, and C_id simultaneously.
So I would think you could just add a field to your fact table named ID. Calculated something like:
if(not isnull(A_ID), A_ID,C_id))