Datamodel

[dandaanilreddy]

Hello Qlik Developers

I have created a dashboard in which i have memberlist table and claims table. i am joining two tables based on claim no and service line no fields. Here i wrote a where condition in claims table as where exists(claim no). The problem with my dashboard its taking very long time to load the claims data may be because on where exists condition. The claims table size is 23 GB. is there anyway i can build the data model in a better way? I tried to debug the app but its not responding. The app is 400 MB. Please find the attached data model image

Thanks,

Anil