data model

[deepakqlikview_123]

Hi All,

Below are the sample fields and sample table can you please suggest how should i handle comman fields and null values.

salestable:

saleid,

name

desc

region

customertable:

custid

name

desc

region

statetable:

stateid,

name

desc

region

salesresulttable:

salesid

result

facttable:

saleid,

custid,

stateid,

profit

loss

date

Thanks

[tamilarasu]

Hi Deepak,

Something like below,

QUALIFY '*';

UNQUALIFY '%*',Profit,loss,date,result;

facttable:

saleid as %salesid,

custid  as %custidsid,

stateid as %stateid,

profit

loss

date

salestable:

saleid as %salesid,

name

desc

region

customertable:

custid as %custid,

name

desc

region

statetable:

stateid as %stateid,

name

desc

region

salesresulttable:

salesid as %salesid,

result

But I am not sure what is your requirement. So, kindly consider this as an Idea.

[Anonymous]

see below threads:

Best Practices for Data Modelling

Best Practices in designing Data Model?

Best practices for Data Modeling

How to Start Data modeling in Qlikview

Data Model best Pratice

[vipin_mishra479 · Accepted solution]

Hey Deepak ,

try to this

salestable:

saleid,

name as Sales_name

desc as Sales_desc

region as Sales_desc

left join

salesresulttable:

salesid

result

customertable:

custid

name as Cust_name

desc as Cust_desc

region as Cust_region

statetable:

stateid,

name as State_name

desc as State_desc

region as State_region

facttable:

saleid,

custid,

stateid,

profit

loss

date

Then reload your script automatically its create star schema.

[deepakqlikview_123]

Thanks bhai how are u?