Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
If you are a Qlik Insight Bot user, join this collaborative group: JOIN GROUP
Highlighted
Contributor

Include Non Existing/Missing Dimension Values

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.

4 Replies
Highlighted

Re: Include Non Existing/Missing Dimension Values

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

Highlighted

Re: Include Non Existing/Missing Dimension Values

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

Contributor

Re: Include Non Existing/Missing Dimension Values

I have reattached. Please check.

Highlighted

Re: Include Non Existing/Missing Dimension Values

Try this expression

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

and uncheck 'Suppress Zero Values' on the presentation tab