Null values in Pivot TABLE

[manu1512]

Hi all,

I am getting these null values in pivot table.Interestingly there are no null values in the fields for which pivot table is giving null values,Please help.

Screenshot attach

App are also attach we are using two tier achitecture one is qvd generator and other one final application.

Issue is in the Pivot table of first tab .Please help

[manu1512]

I tried removing from the chart by supressing it ,but client wants to remove from data model?Any help

Regards

Manu

[sunny_talwar]

Load CO_Objekt first and then load Data with Left Keep (CO_Objekt) and then Kostelem, ProjektInvCo, and Kostelem with Left Keep(Data)

[manu1512]

Hi Sunny,

Thanks for the help but unfortunately i am not getting desired result.Would be grateful if you can check where i am getting wrong, some values of column of Pivot table are getting null values.

Regards
Manu

[sunny_talwar]

Can you share the new script that you tried?

[manu1512]

yes already shared the application in the main post OKG_Controlling_Test qvw.

Thanks in advance stalwar1‌

[sunny_talwar]

With the changes that I mentioned manu1512‌

[manu1512]

Hi Sunny ,

Yes OKG_Controlling_Test qvw. contains the changes mentioned by you.I dont know how to attach application in comments.Please check and let me know my mistakes

Regards

Manu

[manu1512]

stalwar1‌ Please help

[manu1512]

Hi Sunny,

I would be grateful if you can help me more to acheive the desired result.

Regards

Manu

[sunny_talwar]

Not sure, but I see that the data is not loading into Data table after the Left Keep. I am still looking...