Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
citizenk
New Contributor

Handling of missing values (disappear when filter is set)

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

Tags (1)
2 Replies
sergio0592
Valued Contributor II

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

As expression, you can try with :

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

citizenk
New Contributor

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

Hi Jean-Baptiste RENAULT,

Thanks for your reply.

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

Best regards

Ringo

Community Browser