Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Not applicable

Hi,

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

Kiruthi

View solution in original post

2 Replies
Highlighted
Not applicable

Hi,

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

Kiruthi

View solution in original post

Highlighted
Not applicable

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