Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Bradlabs12
Contributor
Contributor

Adding up null/blank value from a Pivot Table in a KPI

I am little new to this product , so hopefully I describe my problem clearly.

I am trying to create a KPI that looks at a pivot table for any time a columns has a blank/null value. 

  • If there is a blank/null value anywhere within the column then that column should be counted in the KPI

I have attached a copy of the pivot table

Thanks for any help

Labels (2)
1 Reply
Arthur_Fong
Partner
Partner

Try this:

MC.PNG

=count(if(len(<Dim>)=0,1,null()))