Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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!

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: How to filter a dimension-only table?

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] )

3 Replies
karthikoffi27se
Contributor III

Re: How to filter a dimension-only table?

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

Re: How to filter a dimension-only table?

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
Valued Contributor III

Re: How to filter a dimension-only table?

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

Community Browser