Build Qlik sense data modal

narayanaqlik — Sat, 21 Dec 2019 07:07:48 GMT

Hi All,

Have a nice day...!

i have 40 tables in my application and all are dimensions tables

Suppose i have 5 entities in my project. Trials , Project Trials Country Trials ,Vendor Trials, Escalated trails

here for trails i have tables like his

Trial Info Table--> Trial Info Id, Trial ID,

Trial Risk/Issues table,--> Trial Risk/Issue ID, Trial ID, Created Date, Updated date (Respective of this table dates)

Trial Map table-->Trial MapID, Trial Risk/Issue ID,Created Date, Updated date(Respective of this table dates)

Trial Action table, --> Trial Action ID, Trial Risk/Issue ID, Created Date, Updated date(Respective of this table dates)

Like this i have tables for other entities also...

How can i create data modal , which one is the best to create data modal .

Would you please any one help here for creating good data model.

Re: Build Qlik sense data modal

andoryuu — Fri, 03 Jan 2020 14:26:45 GMT

Qlik Sense Engine works best with fact tables that are surrounded by a single level of dimension tables. If your example above, it looks like you are dealing with a snowflake schema instead of a star schema (QS preferred method). If Trial Info is your fact table (has your measures) then you'd want to join your Trial Risk/Issues table with the Trial Map table and Trial Action table to have a single dimension to join to your Trial Info table.

The scope of your question is huge and I'm not sure what "respective of this table dates" means, but Qlik has a two day data modeling course that I highly recommend you take to get a good grasp of the best practices in this regard.

topic Build Qlik sense data modal in App Development

Build Qlik sense data modal

Re: Build Qlik sense data modal