Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Suggest Best Data Modeling in this situation??

Hi All,

I have four tables

1.Material Base (like master)it contains "plant&material". it doesn't contain year and month.

2.Mard

3.Mssl

4.ZZMM

rest of the three contains plant,material,year&month.

In the front end we need to use plant,material from "Material Base" only and common year and month for all tables.

we need to show mard-stock separately,Mssl-Stock separately and ZZMM-Stock separately for plant and material wise which is coming from Material Base table.

What i did : created hard coded master calender and outer join with Material Base table after that i given link to all other tables with "Plant&Material&year&Month". But i think this is not accurate because with out any reference i joined calender and Material base table.

so suggest me any good way.

Thanks in advance,

Ashok.

4 Replies
umerikhlas
Not applicable

Re: Suggest Best Data Modeling in this situation??

Can you add more details about your tables? fields for every table separately. so that it could be more easy to understand your need.

Not applicable

Re: Suggest Best Data Modeling in this situation??

If possible can u share the table view of your data that will be more easy to understand and help you.

avinashelite
Not applicable

Re: Suggest Best Data Modeling in this situation??

Hi Ashok,

Please share sample data, so that it will helpful for to suggest.

Regards,

@vi

Not applicable

Re: Suggest Best Data Modeling in this situation??

Material Base-Table

Plant , Materialgroup , Material

MARD-Table

Plant  ,Materialgroup, Material,  Year,  Month , Stock

MSSL-Table

Plant  ,Materialgroup  ,Material,  Year,  Month,  Stock

ZZMM-Table

Plant , Materialgroup , Material  ,Year , Month , Stock