Handling of missing values (disappear when filter is set)

citizenk — Thu, 31 Aug 2017 14:08:31 GMT

Dear all,

I created a Pivot table to show gaps (missing values).

Though I know that Qlik has some disadvantages when it comes to the handling of NULL and MISSING values I managed to have the gaps shown as missing by setting the replacement in the chart properties > presentation.

The calculation of the counts seen in green are realised by a simple count(distinct ARTICLES)

However when I am filtering to one of the values (Article Group IDs) in the header like 5,7,8,...) the gaps disappear and I end up with values that do exist but not the gaps (gaps=vehicles that don't have a value for ID 7):

I reckon this is because in the fully shown table (you only see an excerpt and it continues on the right side) are some values existing for this particular vehicle but not for ID 7 and therefore Qlik fills up the other IDs with "missing". Filtering for 7 leads to having only vehicles shown where ID 7 is associated to. That's how far I understand the behaviour.

Is there a way to alter the expression to keep the gaps though filtering for an ID?

Sorry for being not able to provide a file since it is quite huge.

Thanks in advance.

Ringo

Re: Handling of missing values (disappear when filter is set)

sergio0592 — Thu, 31 Aug 2017 15:29:29 GMT

As expression, you can try with :

count ( {<Article Group ID -= {""}>} distinct Articles)

Re: Handling of missing values (disappear when filter is set)

citizenk — Fri, 01 Sep 2017 07:09:49 GMT

Hi Jean-Baptiste RENAULT,

Thanks for your reply.

Sadly this has no effect and it acts the sam as before.

Best regards

Ringo

topic Re: Handling of missing values (disappear when filter is set) in QlikView

Handling of missing values (disappear when filter is set)

Re: Handling of missing values (disappear when filter is set)

Re: Handling of missing values (disappear when filter is set)