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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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.

Labels (1)
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()