topic Re: Include only these Dimensions in Set Analysis in QlikView

Include only these Dimensions in Set Analysis

Anonymous — Fri, 08 Jan 2016 14:47:22 GMT

=count(distinct{<[Enrollment Counter Date]={'>$(vPriorMonth12Max)'},[Eligibility Benefit Type]={'Medical'},[Claim Paid Period]=,[Enrollment Period]=>}[Member Months Counter]),

I have this formula in my application and I want to only include current selections from two of my possible dimensions to determine my chart output. I have 100 dimensions in my app and want to ignore current selections from any others.

I know how to exclude specific dimensions in Set Analysis by using [Claim Paid Period]= It obviously is not practical to add all of them in this matter.

How do I specify in Set Analysis to only include selections from my two desired dimensions [Name] and [Group Number] and ignore the rest?

Re: Include only these Dimensions in Set Analysis

swuehl — Fri, 08 Jan 2016 15:24:35 GMT

Try something like

Count( {1<[Name] = $::Name, [Group Number] = $::[Group Number] >} FieldName)

Re: Include only these Dimensions in Set Analysis

sfatoux72 — Fri, 08 Jan 2016 15:43:54 GMT

swuehl is right.

Just to explain her solution :

Count( {1<[Name] = $::Name, [Group Number] = $::[Group Number] >} FieldName)

1 To specify that we use the entire set of data without take care of the user selection

[Name] = $::Name To specify that we will assign to the field "[Name]" of the Set Analysis values of the field "Name" defined by the user selection ($)

Re: Include only these Dimensions in Set Analysis

Anonymous — Fri, 08 Jan 2016 15:50:01 GMT

I am testing this right now. As you can see, I have a variable filter and a static filter in my example above. Can this solution work in conjunction with those?

Re: Include only these Dimensions in Set Analysis

sfatoux72 — Fri, 08 Jan 2016 15:52:38 GMT

Yes, without problem

Re: Include only these Dimensions in Set Analysis

Anonymous — Fri, 08 Jan 2016 16:17:42 GMT

Thanks to both of you! I was able to make it work! I looked pretty extensively through the forum and did not find anything like this. This looks like a good topic for the resource library. One of the two of you should create a document to post on this.

Re: Include only these Dimensions in Set Analysis

sfatoux72 — Fri, 08 Jan 2016 16:28:31 GMT

You could find information about this solution here:

Set analysis and set expressions about the identifier 1
Examples of Alternate States in Chart Expressions about the selection [Name] = $::Name