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

[Chanty4u]

try to debug

take a copy of table.

remove one by one dimension and check which dimension you are having the null value.

based on dimension the related values may not avaiable 

try to uncheck the dimension tab suppress null values for dimensions

[shiveshsingh]

Can you share your app? May be for some dimension you don't have value..u need to check

[Digvijay_Singh]

Its not necessary that you get null values only when you have null values in any of the field. You might get null values when you choose fields in your pivot tables from different tables and they don't give you valid combinations based on matching keys. You may like to verify your dimension values for which you are seeing null values in your pivot table.

[manu1512]

done

[manu1512]

stalwar1‌cleveranjos‌s10157754‌ pls help

[sunny_talwar]

Some of the fields (for example, Avdelning and Enhet) are coming from CO_Objekt which have a subset ratio of 97%... meaning... not everything in Data have a match within CO_Objekt... hence the nulls

[Chanty4u]

woow    Nice sunny

[manu1512]

Hi Sunny ,

Many thanks for the Solution,Would b grateful if you can suggest new solution to remove this .

[sunny_talwar]

You want to get rid of these from the data model or just from the chart? For chart, you can select Suppress When Value Is Null on the dimension tab for the dimensions which are showing null....