Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II
‎2018-06-19 10:24 AM

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

USE_CASE.qvw
329213USE_CASE.qvw
218 Views
0 Likes
0 Replies