topic Re: How can i create Data model based on my Excel in QlikView

How can i create Data model based on my Excel

Srinivas — Fri, 13 Jun 2014 07:36:55 GMT

Hi All,

How to create Data Model Based on my screen shot,

Please suggest me as soon as i waiting very eagerly to your replay.

Advance & Thanks

Munna

Re: How can i create Data model based on my Excel

Fri, 13 Jun 2014 07:44:59 GMT

Hi Munna,

Create a data model by loading each tab as a single table and by linking those fields as per your business requirement like Country, Year or month fields.

Kumari.

Re: How can i create Data model based on my Excel

Srinivas — Fri, 13 Jun 2014 14:02:54 GMT

Hi Kumari,

I created same based on Year link.

but here have country and LOB also same fields in all tabs.

We can add all tabs into one table.

Regards

Munna

Re: How can i create Data model based on my Excel

Fri, 13 Jun 2014 14:06:36 GMT

Like all tables on something such as Year Month and use joins to help optimize your model and remove synthetic tables

Re: How can i create Data model based on my Excel

datanibbler — Fri, 13 Jun 2014 14:07:18 GMT

Hi Munna,

adding (concatenating?) all tabs into one table would be difficult as you have a lot of specific fields, thus that one table would have a lot of blank fields.

If, like here, you have fields with the same name, but different contents, between different tables, you can avoid the automatic linking QlikView does by renaming the fields (either qualify them with the table name, but that can be tricky, I would not suggest to do so, or just use the AS option and enter another name.

HTH

Best regards,

DataNibbler