Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rittermd
Master
Master

Filter Issue

I have a filter called Country.  It has two values (Canada, USA).

When dashboard opens and I click on this filter I see both values in white indicating that they both exist in the data.  When I select Canada I get records.  When I select USA I get nothing.

Why would it be white if there is no data?  

2 Replies
chrismarlow
Specialist II
Specialist II

Hi,

Might be your data model - USA & Canada could be in a field on one table and your visualisations on your sheet from another table, where linked records only exist for Canada?

Cheers,

Chris. 

rittermd
Master
Master
Author

That would seem reasonable.  However, I only have a single Fact Table in my data model and it contains this field.  I'm sure has something to do with my data model.  I just can't figure it out.