null problem

[#1]

Dear Community

i have build data model with some excels

there is no null in any excel

but in charts its showing some null and values also showing little gigh

any ides where was the problem pls share the idea

[jvishnuram]

can you post your docment because i was not clear with your task

[hic]

You can get NULLs in QlikView not only from the source data (the Excel sheets) but also from Joins and Concatenations in the script. Further, there are "Missing values" which is something you can get in your charts when the combination of dimension and expression "expects" a value but there is no corresponding value in the data.

See more on http://community.qlik.com/docs/DOC-3155

HIC