Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
SunainaUmberkar
Contributor III
Contributor III

Data Model Issue in QLiksense

Hello All,

I have an issue wrt to Data Model. I have a Qliksense App, where 6 tables are used. 4 tables are linked with a common column as Userid and other 3 must link with user_transaction field, when I am doing so I am getting a circular reference. 
To avoid circular reference we are aware that we must rename or remove the field but in this  case we cannot do both as the data wont appear properly. Kindly assist how can we resolve this. 

PassportData, User role transaction usage, Sod SUmmary and User Master must be linked with Userid field and User role transaction usage,Sod detailed and Yearly_Trans_Usage must be linked with user_transaction. 

SunainaUmberkar_0-1648451731822.png

Thanks in advance.

 

Labels (1)
9 Replies
justISO
Specialist
Specialist

Hi, as I understand from your description, you are linking these tables with only 2 keys, Userid and user_transaction, so maybe field User_Master.key is not needed as a key? in this case just rename it f.e. key2 and loop should disappear - no more link between tables User_Master and SOD_Detailed_New.

SunainaUmberkar
Contributor III
Contributor III
Author

Hello JustISo,

Thanks for the reply.

I forgot to mention as I require a link between User_Master and SOD_Detailed_New as well. Hence I have created a Key between this 2. If this is not created my data is not as expected. 

 

justISO
Specialist
Specialist

My other suggestion in this case would be to join some tables (if not all) if possible to get rid of links at all. Approach for this is depending on table structures, duplicates existence and so on, but something like this can be as a start maybe:

left join (User_master)
SOD_detailed_new:
load...

SunainaUmberkar
Contributor III
Contributor III
Author

Hello justISo,

Thanks. Are you suggesting to remove key and then do a left join with User Master?

I tried to do a left join between SOD_Detailed_new and User role transaction usage table based on user id, but data load time was increased and my app was loading for around an hour, so i aborted it. 

 

justISO
Specialist
Specialist

Not remove 'key' as a field, but from two tables, using inner/left join, make only one table, so there will be no relation link between those tables needed. You will remove relation which cause loop (between tables with fields 'key'), but will get synthetic key user_transaction + user ID, which I guess should not brake anything. But I'm starting to guess that in your case this can be a tricky part also, as your tables seems quite big. So already doubting, that my suggestions are good.

SunainaUmberkar
Contributor III
Contributor III
Author

Hello,

Thanks for the suggestion. Will try to implement and check. Yes since the table is huge, doing a left join between tables is increasing load time. 

SunainaUmberkar
Contributor III
Contributor III
Author

Hello,

Left join/Inner join is not working in this scenario. I tried to concatenate sod_detailed_new and user_master but data in front end has issues. Do we have any other option for this type of scenario. Kindly help. 

Thanks in advance.

 

 

 

Prashant_Naik20
Contributor
Contributor

Hi,

Try to rename the UserId field of User role transaction usage table. See if that helps.

Regards,

Prashant

SunainaUmberkar
Contributor III
Contributor III
Author

Hello Prashant,

That is helping to resolve circular reference, but i require that field as if i remove that link data is not coming properly. I tried all other options as well but nothing is solving my issue. Any suggestions on how to handle this?

Thanks in advance.