topic Re: data model in QlikView

data model

deepakqlikview_123 — Mon, 23 Nov 2015 07:25:23 GMT

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

Re: data model

tamilarasu — Mon, 23 Nov 2015 07:31:50 GMT

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.

Re: data model

Anonymous — Mon, 23 Nov 2015 07:32:26 GMT

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

Re: data model

vipin_mishra479 — Mon, 23 Nov 2015 07:46:53 GMT

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.

Re: data model

deepakqlikview_123 — Mon, 23 Nov 2015 08:04:35 GMT

Thanks bhai how are u?