topic Reqirement for data modelling in QlikView

Reqirement for data modelling

deepakqlikview_123 — Thu, 19 Jun 2014 08:53:26 GMT

Hi all,

Can you please suggest what would be requirement for data modelling when we are going to use tables from OLTP environment.

Moreover also suggest how to build schema.

Thanks

Re: Reqirement for data modelling

IAMDV — Thu, 19 Jun 2014 08:56:31 GMT

Deepak,

It's hard to give answer on the fly. I'd suggest you to provide the sample schema and the requirements. There is no hard rule while data modelling because it all depends on the requirements. It's art as much as it's science.

Thanks,

www.QlikShare.com

Re: Reqirement for data modelling

deepakqlikview_123 — Thu, 19 Jun 2014 09:07:03 GMT

Hi Deepak,

Thanks for reply.

Please look into below code.

Retail:

load

DealerID

resident OrganisationMaster;

Left Join

load

'' as ret

Resident Dealer1;

After left join

Is dealer id visible in Retail table.

Thanks