Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Filter on table

Hi,

I got a table reporting all the details of my values.

I should put in a condition to have it showing just rows where the field "Overall" is "KOB"

I'm using {<"Overall"={'KOB'}>} but is not working!

Any idea?

Thanks in advance

Bruno

1 Solution

Accepted Solutions
Not applicable
Author

Enclosed the document.

Kiran.

View solution in original post

9 Replies
Not applicable
Author

Try it as {<Overall={'KOB'}>}. I am not sure what happends if double quotes for field name as placed. However this would only work in a set analysis senario.

Kiran.

Not applicable
Author

still not working!

Not applicable
Author

Can you try with all selections cleared as well as other filters removed from set analysis? Since your filter is text field can you make sure if the exact text is available?

If the problem presists can you share a sample of your app for us to debug?

Kiran.

Not applicable
Author

Hi,

the issue is the table is actually showing all the values even if I included the condition.

Not applicable
Author

Hi,

There are only two possiblities for the issue.

1) The filter is not included. Which means something is work with the syntax or the text name.

2) The filter is included but is overridded some how. For this I would like to ask where the set analysis is used. Can you specifty what other expressions and dimensions are used in this table and what selections are made?

Kiran.

Not applicable
Author

attached the report, there is the same condition on graph and details

OVERALL =KOB

Not applicable
Author

Hi,

I add the Overall dimension to the chart and changed into a straight table. It seems the filter is applied only as I can see only KOB records.

Not applicable
Author

Thanks Kiran,

could I see what you did?

Not applicable
Author

Enclosed the document.

Kiran.