Discussion board where members can get started with QlikView.
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:
my code is:
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...
Have a look at the attached application,hope it helps!!
View solution in original post
You can use Count(ALL DISTINCT week) - Count(week) keeping Ref as Dimension.