Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Goodman_UPS
Contributor II
Contributor II

Tabular Reporting - Creating a Filter based on a dimension

When trying to create a filter in the 'Filter' section of Reporting, I have trying to filter based on a dimensional value.

When I select the dimension, it just appears as my if statement in the dimension.  I chose search, evaluate, etc. to find the value that I want but it keeps telling me it is invalid.

How do I filter based on a dimension

Labels (1)
5 Replies
igoralcantara
Partner Ambassador/MVP
Partner Ambassador/MVP

It is not clear what happened. Can you share a screenshot and explain what values you expect to see?

Check out my latest posts at datavoyagers.net
Goodman_UPS
Contributor II
Contributor II
Author

Thanks for looking into this.  Attached a screenshot.

igoralcantara
Partner Ambassador/MVP
Partner Ambassador/MVP

Oh, is that a calculated dimension? I don't think that works.

Check out my latest posts at datavoyagers.net
Goodman_UPS
Contributor II
Contributor II
Author

Yes, it is a calculated dimension.

igoralcantara
Partner Ambassador/MVP
Partner Ambassador/MVP

You will have to add the dimension to your data model. I do not believe filters in Tabular Reporting work with calculated dimensions.

Check out my latest posts at datavoyagers.net