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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
louisernould
Contributor III
Contributor III

Count Number of empty data in Columns in Pivot Table

Hi Qlik Community !

Everything is in the title: I have a pivot table and I want to count the number of empty data in my pivot table.

In an excel file, I have something like that:

RefWeek1Week2Week 3Week 4
A23

3

B

1

222
C11
D114
E2222
F16

my code is:

CrossTable(week,test, 1)

LOAD

     Ref,

     Week1,

     Week2,

     Week3,

     Week4

FROM

[...]

I'm looking for a code to have a table like this one:

Refnumber of null
A2
B0
C2
D1
E0
F2

Does someone have an idea ? I tried with a loop but it wasn't good...

1 Solution

Accepted Solutions
Not applicable

Hi,

Have a look at the attached application,hope it helps!!

Kiruthi

View solution in original post

2 Replies
Not applicable

Hi,

Have a look at the attached application,hope it helps!!

Kiruthi

Not applicable

You can use Count(ALL DISTINCT week) - Count(week) keeping Ref as Dimension.