Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Data-model in QlikView


I have a xls, Where 5 Sheet are available. All the fields are different in each sheet and where jm_v_rep_topfeat_relation Sheet have the 3 Fields Where all the Combination are linked with another 4 Sheets. i.e : TFEAT_DOCUMENTKAY, RELATED_DOCUMENTKEY and RL_NAME. If you will check this fields value you can assume how it combined with another 4 sheets value.

Please find the attached xls and QVW for Data and code. I have tried by using linking model, but it is creating Cartesian Product (Cross Join) and going in loop.

QVW is in Debug mode, Not Full reload, When I am making full reload, data is going upto 70 Million.

So Please Can anyone help me for making a relation with all 5 sheet / fields.

Thanks & Regards,


0 Replies