Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion III
Champion III

RE:Null display

Hi all,

I have a issue .

i have one filter like

Year

2000

2001

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

Best

Chanty

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: RE:Null display

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?

=NullCount(Field)

View solution in original post

5 Replies
Highlighted
MVP
MVP

Re: RE:Null display

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?

=NullCount(Field)

View solution in original post

Highlighted

Re: RE:Null display

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?

Highlighted
Champion III
Champion III

Re: RE:Null display

yes sunny....

but  if i want show in Pivot or stright table ? how can i do this?

Highlighted

Re: RE:Null display

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

Highlighted
Champion III
Champion III

Re: RE:Null display

thnku stefan and sunny