topic Re: How to get the blank count in pivot table? in QlikView https://community.qlik.com/t5/QlikView/How-to-get-the-blank-count-in-pivot-table/m-p/584841#M1098567 <HTML><HEAD></HEAD><BODY><P>use nullcount()</P></BODY></HTML> Wed, 16 Apr 2014 11:30:53 GMT sujeetsingh 2014-04-16T11:30:53Z How to get the blank count in pivot table? https://community.qlik.com/t5/QlikView/How-to-get-the-blank-count-in-pivot-table/m-p/584838#M1098564 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>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.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 16 Apr 2014 11:11:18 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-blank-count-in-pivot-table/m-p/584838#M1098564 2014-04-16T11:11:18Z Re: How to get the blank count in pivot table? https://community.qlik.com/t5/QlikView/How-to-get-the-blank-count-in-pivot-table/m-p/584839#M1098565 <HTML><HEAD></HEAD><BODY><P>As usual please provide sample data file or sample apps.</P></BODY></HTML> Wed, 16 Apr 2014 11:13:06 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-blank-count-in-pivot-table/m-p/584839#M1098565 MK_QSL 2014-04-16T11:13:06Z Re: How to get the blank count in pivot table? https://community.qlik.com/t5/QlikView/How-to-get-the-blank-count-in-pivot-table/m-p/584840#M1098566 <HTML><HEAD></HEAD><BODY><P>Please see attached.</P></BODY></HTML> Wed, 16 Apr 2014 11:14:01 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-blank-count-in-pivot-table/m-p/584840#M1098566 2014-04-16T11:14:01Z Re: How to get the blank count in pivot table? https://community.qlik.com/t5/QlikView/How-to-get-the-blank-count-in-pivot-table/m-p/584841#M1098567 <HTML><HEAD></HEAD><BODY><P>use nullcount()</P></BODY></HTML> Wed, 16 Apr 2014 11:30:53 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-blank-count-in-pivot-table/m-p/584841#M1098567 sujeetsingh 2014-04-16T11:30:53Z Re: How to get the blank count in pivot table? https://community.qlik.com/t5/QlikView/How-to-get-the-blank-count-in-pivot-table/m-p/584842#M1098568 <HTML><HEAD></HEAD><BODY><P>I need the label as 'Default' in horizontal also? where can I use nullcount()</P></BODY></HTML> Wed, 16 Apr 2014 13:34:23 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-blank-count-in-pivot-table/m-p/584842#M1098568 2014-04-16T13:34:23Z