topic Re: Include Non Existing/Missing Dimension Values in QlikView

Include Non Existing/Missing Dimension Values

gizzel123 — Thu, 27 Jul 2017 18:36:39 GMT

Dear Friends,

I have a very different requirement. I have some fields namely Plant_ID, Product,and Geography (State/City) etc etc.

Requirement is a table of :State vs Count(Plant_id) with filters like Product etc..

But in my case even if we select any specific Product for which some states doesnt have plant should up show in the table . Thouh they will appear with zero plant_id .

For example . US has 51 states in this scenario. and if I select Product=2, then data gets reduced to 33 rows . Which is correct. But the requirement is to show the rest of the 22 States with zero count(plant_id).

I am attaching a sample QVW for reference.

Your Help is much appreciated!!

Thank you.

Attached a new QVW as the previous one wasn't opening due to section access.

Re: Include Non Existing/Missing Dimension Values

sunny_talwar — Thu, 27 Jul 2017 19:29:48 GMT

Attached qvw seems to have section access... can you repost without section access

Re: Include Non Existing/Missing Dimension Values

sunny_talwar — Thu, 27 Jul 2017 19:30:35 GMT

Also, did you try to uncheck 'Suppress Zero Values' on the presentation tab?

Re: Include Non Existing/Missing Dimension Values

gizzel123 — Fri, 28 Jul 2017 07:36:22 GMT

I have reattached. Please check.

Re: Include Non Existing/Missing Dimension Values

sunny_talwar — Fri, 28 Jul 2017 11:07:09 GMT

Try this expression

=Count(DISTINCT plant_id) + Avg({1} 0)

and uncheck 'Suppress Zero Values' on the presentation tab