topic Count Null values in pivot in QlikView

Count Null values in pivot

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How can i count the null values for max month from this pivot table?

expression: Sum({<Kontonr={4297,4298,4299}>}[Bokført beløp])

Re: Count Null values in pivot

prieper — Mon, 17 Jul 2017 12:19:53 GMT

Think that you need to construct a cartesian product betw accounts and month. Then you should be able to count all non-occurences within selected monthes.

Peter

Re: Count Null values in pivot

Anonymous — Mon, 17 Jul 2017 12:26:52 GMT

Hi, Thanks for reply

Got an example for that?

Re: Count Null values in pivot

prieper — Mon, 17 Jul 2017 12:35:52 GMT

just as aircode:

RunningCalendar: LOAD MONTH(Date) AS Maned INLINE (Date

1/1/2017

1/2/2017

1/3/2017

1/4/2017

......];

JOIN LOAD (RunningCalendar) DISTINCT Account FROM ....;

With this you should have a big table with an entry for each Month and existing Account.

Peter

Re: Count Null values in pivot

Sergey_Shuklin — Mon, 17 Jul 2017 12:38:25 GMT

Hello, Marius!

You can check this topic:

checking null in set analysis

You can use expressions from there and modify them with maxdate condition, and you should get what you are lookin for.