Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Data-model in QlikView

Hi,

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,

AK

0 Replies