topic Filter on table in QlikView

Filter on table

Wed, 02 Nov 2011 09:42:28 GMT

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

Filter on table

Wed, 02 Nov 2011 09:50:53 GMT

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.

Filter on table

Wed, 02 Nov 2011 10:38:46 GMT

still not working!

Filter on table

Wed, 02 Nov 2011 10:44:43 GMT

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.

Filter on table

Wed, 02 Nov 2011 11:01:18 GMT

Hi,

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

Filter on table

Wed, 02 Nov 2011 12:01:34 GMT

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.

Filter on table

Wed, 02 Nov 2011 12:32:32 GMT

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

OVERALL =KOB

Filter on table

Wed, 02 Nov 2011 12:40:29 GMT

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.

Filter on table

Wed, 02 Nov 2011 12:44:06 GMT

Thanks Kiran,

could I see what you did?

Re: Filter on table

Wed, 02 Nov 2011 13:53:40 GMT

Enclosed the document.

Kiran.