Count Number of empty data in Columns in Pivot Table

louisernould — Thu, 02 Oct 2014 15:32:00 GMT

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:

Ref	Week1	Week2	Week 3	Week 4
A	2	3		3
B	1	2	2	2
C			1	1
D		1	1	4
E	2	2	2	2
F	1			6

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:

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

Re: Count Number of empty data in Columns in Pivot Table

Thu, 02 Oct 2014 15:48:35 GMT

Hi,

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

Kiruthi

Thu, 02 Oct 2014 15:50:56 GMT

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