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: 
Not applicable

How to filter a dimension-only table?

Hi All,

I have a table that will only show two dimensions (title and description), no measures. How can I filter the table to only show a certain type of records? (e.g. I have a table of player positions in various sports and a description of the position. I want to filter out rugby and baseball and only show football)

Thanks in advance!

1 Solution

Accepted Solutions
Not applicable
Author

Thanks Karthik! It's actually even easier than that, the answer was staring me in the face

In the field to enter the dimensions, use an if statement:

=IF( [FieldName] = 'DesiredFieldValue', [FieldName] )

View solution in original post

3 Replies
karthikoffi27se
Creator III
Creator III

Hi Katherine,


You can create a list box and use the option under appearance, check in


Always One Selected Value*

[Define your values that to be listed in the TAB]

Disable the - Show titles


Reduce the size of the table to it's minimum and try to hide it in a corner.


Then add in your dimensions in your straight table. This will be a temporarily solution until conditions is enabled.


Hope this helps

Many Thanks

Karthik

Not applicable
Author

Thanks Karthik! It's actually even easier than that, the answer was staring me in the face

In the field to enter the dimensions, use an if statement:

=IF( [FieldName] = 'DesiredFieldValue', [FieldName] )

miguelbraga
Partner - Specialist III
Partner - Specialist III

Hi Katherine,

Can you post a screenshot of your table?

Did you try to use a set analysis dimension in which you show only your selection from the list box?

Regards,

MB