Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

how do i link an sap table with a different date field with my calendar

Hi everybody,

I have a table MSEG from SAP which i need to include in my current data model .

I have a master calendar created on the transaction table VEKP.

The MSEG table has a field posting_date.

I am failing to understand how do i connect it with my current data model .

I have tried to link it with material code but the master calendar does not work .

I have attached a screenshot of the data model for reference.

Please help

Regards,

Nadeem shaikh

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: how do i link an sap table with a different date field with my calendar

I don't call it like MASTER calendar, just another calendar table.

Why not? and you can show this calendar as Year, Month etc on the particular tab only.

Regrades.

Sergey

Regards,
Sergey

View solution in original post

6 Replies
Highlighted
Partner
Partner

Re: how do i link an sap table with a different date field with my calendar

Hi,

Could you explain your business requirements.

It looks like you need to concatenate two data tables... but everything depends on your requirements..

Regards,

Sergey

Regards,
Sergey
Highlighted
Specialist
Specialist

Re: how do i link an sap table with a different date field with my calendar

Hi,

I need to calculate this formula which is based on the MSEG table

=sum({<Material_Code={600327,600329,600373,607369},[MSEG.Movement Type_BWART]={'261','262','701','702'}>}MSEG.Quantity)/(Sum({<[MARA.Material Type_MTART]={'FERT'}>}[VEKP.Loading weight_NTGEW]/1000)) .

I have already built the formula but the dates do no effect the chart that i have created using the above formula .

Highlighted
Partner
Partner

Re: how do i link an sap table with a different date field with my calendar

So. I don't know why did you connect your calendar to VEKP and GLASS_MELT,

but because as I see it's a Material Management you probably need it.

So, as a solution you can create another calendar and connect it to Posting Date.MSEG

Regards,

Sergey

P.S. AS I remember in one of the MM apps I had around 5 calendars. It's not bad, if you need it.

Regards,
Sergey
Highlighted
Specialist
Specialist

Re: how do i link an sap table with a different date field with my calendar

Hi,

I am sorry for the late reply ,was travelling .

I connected the master calendar because the VEKP was the main transaction table.

With reference to your reply I have question if you could please clarify, you mean to say for this particular KPI i will have to use a completely different master calendar which will have to stay away from the dashboard on a different sheet and that calendar will used only for that particular report??? .

Regards,

Nadeem

Highlighted
Partner
Partner

Re: how do i link an sap table with a different date field with my calendar

I don't call it like MASTER calendar, just another calendar table.

Why not? and you can show this calendar as Year, Month etc on the particular tab only.

Regrades.

Sergey

Regards,
Sergey

View solution in original post

Highlighted

Re: how do i link an sap table with a different date field with my calendar

IMHO you'll have to find a connection between VEKP (Sales/delivery doc headers) and MSEG (Movements) first. Otherwise you'll be dividing unrelated things in your formula. I'm guessing that MATNR will not be enough.

A connection between MSEG and VEPO (SD items) will probably be easier to find, after which you can JOIN in the headers from VEKP