Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get the blank count in pivot table?


Hi,

I have a Pivot table . I need to show the blank values count. I can able to get the count. But my problem is I can able to make the blank values label as 'Default' in both horizontal and vertical. I an able to get in vertical. I need in horizontal? Is it possible. Please see attached.

Thanks.

4 Replies
MK_QSL
MVP
MVP

As usual please provide sample data file or sample apps.

Not applicable
Author

Please see attached.

sujeetsingh
Master III
Master III

use nullcount()

Not applicable
Author

I need the label as 'Default' in horizontal also? where can I use nullcount()