Selections filtering does not work properly when SET analysis is used

Wed, 12 Dec 2012 13:56:16 GMT

Hi,

I need your help. I have created a document with several tabs. I found that Selections or filtering does not work properly when I use an expression with SET Analysis. I have created Chart Tables in different tabs. In the tabs that contain tables with a column with an expression like the one below does not filter well. All other tabs that do not contain expression like this filter/select fine.

So, I have a table like this:

Project Name, Project ID, Completion, Section

The Completion column contains the expression:

count( {1<[Completion] = {'Green'}, [Section] = {2} >} [Completion])

The table show all correct data, when I click on 'Project Name'I expect all rows to hide but the one that contains the project name I click on, just like the other tables in the other tabs. The filter shows in the Current Selections object, but the table still shows all the rows.

In addition, I noticed that the values for the columns that do not contain SET Analysis is filtered out, and the values for the other columns is still shown.

So, in the table above, when I apply the filter:

1. I click on a Project Name value

2. The Project Name is shown in the Current Selections

3. All rows are still shown

4. Values for Project ID and Section are only shown for the project name selected

5. All values are shown in the column Completion

If I disable/remove the column Completion Selections works fine, as expected like other tables that do not contain these type of expressions.

Using SET Analysis is very appropriate for our data model, and very fast in terms of performance. So I prefer so use these instead of load scripts which take longer to load to achieve the same results.

Any help is very much appreciated.

Thanks,

Alexis

Re: Selections filtering does not work properly when SET analysis is used

Gysbert_Wassenaar — Wed, 12 Dec 2012 14:05:14 GMT

The 1 in the expression count( {1<[Completion] = {'Green'}, [Section] = {2} >} [Completion]) means disregard all selections. If you don't want that remove that 1.

Re: Selections filtering does not work properly when SET analysis is used

Wed, 12 Dec 2012 14:07:03 GMT

I have replaced with $, it works, thanks very much.

topic Re: Selections filtering does not work properly when SET analysis is used in QlikView

Selections filtering does not work properly when SET analysis is used

Re: Selections filtering does not work properly when SET analysis is used

Re: Selections filtering does not work properly when SET analysis is used