Discussion Board for collaboration related to QlikView App Development.
I have a issue .
i have one filter like
2002 lik dat ..... and i have a bar chart . so my requirment is :
in that years i have some null values. so when i ever i clik on any year for that year null values should display on chart?
how can i do this?
Thanks in advance
NULL is not a value, so I am not sure what you want to show in your chart.
Maybe the count of records with NULL?
View solution in original post
How can you display null values? You mean to display the count of Null value?
May be Year as dimension and NullCount(Value) as Expression?
but if i want show in Pivot or stright table ? how can i do this?
The same way as Stefan and I mentioned. Add an expression NullCount(Value) with year as your dimension and all other dimensions you may have
thnku stefan and sunny