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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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