Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
manu1512
Creator
Creator

Null values in Pivot TABLE

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

27 Replies
manu1512
Creator
Creator
Author

Thanks let me know if you get any thing

sunny_talwar

I think you will need to look at KostställeNyckel in the app before you implemented Left Keep... I don't have the time to drill down into the issue, but something is not right about it... Kostnadsställe is missing in some times... which is always available in CO_Objekt... I don't think I can give any more things from here onwards

manu1512
Creator
Creator
Author

Thanks a lot Sunny

manu1512
Creator
Creator
Author

Hi stalwar1loveisfail‌ now subset ratio is almost 97 percent .Still same issue is getting .I suspect since first column  in Pivot table are coming from two different table .Thats why it is showing null values .Would be grateful if you can help me in solving this issue

Regarding

Manu

sunny_talwar

97% was where we began from

Capture.PNG

manu1512
Creator
Creator
Author

sorry this is compressed data in full data it was only 64 still getting same issue ..

kaushik.solankicleveranjosdmohanty

sunny_talwar

Yup, no idea Manu... may be others can help

manu1512
Creator
Creator
Author

Hope so