Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts - Just wanted to know whether my attached table structure is good to build the dashboards? What are Pro's and Con's ? Please clarrify... Have attached the table structure as well
Hi,
Your data model seems , Circular loop, need to remove the circular loop.
join SUB_Region table with COS table. or use of mapping load/Apply map. reduce the table.
Hope it will help.
Your model has a looped association structure which forced Qlik to create loosely coupled associations (the dashed lines). These will often give results different to what you might expect. In general, loosely coupled tables are an indication of a poor model design.
Personally, in over 10 years of Qlikview and Qlik Sense, i have never seen a valid use case for a model with loosely coupled tables. So the recommendation would be to redesign your data model. If you are using Qlik Sense, load the data via the Data Manager if you are uncertain.
Is this model fine?
Since nobody else had replied, I wanted to let you know it looks much better than your previous model and should be functioning better, but I am not a very good developer, so take this with the proverbial grain of salt, but if things are performing well, I would say you should be in good shape at this point. Sorry I am not more help.
Regards,
Brett