Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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 - Creator III
Partner - Creator III

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

----
datavoyagers.net
Goodman_UPS
Contributor II
Contributor II
Author

Thanks for looking into this.  Attached a screenshot.

igoralcantara
Partner - Creator III
Partner - Creator III

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

----
datavoyagers.net
Goodman_UPS
Contributor II
Contributor II
Author

Yes, it is a calculated dimension.

igoralcantara
Partner - Creator III
Partner - Creator III

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

----
datavoyagers.net