2 Replies Latest reply: Aug 31, 2017 10:08 AM by Ringo Keller RSS

    Handling of missing values (disappear when filter is set)

    Ringo Keller

      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.

       

      1.jpg

      2.jpg

      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):

       

       

      3.jpg

      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