Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Can you share your app? May be for some dimension you don't have value..u need to check
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.
done
stalwar1cleveranjoss10157754 pls help
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
woow Nice sunny
Hi Sunny ,
Many thanks for the Solution,Would b grateful if you can suggest new solution to remove this .
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....