Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gizzel123
Creator
Creator

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
sunny_talwar

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

sunny_talwar

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

gizzel123
Creator
Creator
Author

I have reattached. Please check.

sunny_talwar

Try this expression

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

and uncheck 'Suppress Zero Values' on the presentation tab