Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

lubicz99
Valued Contributor

Include only these Dimensions in Set Analysis

=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?

1 Solution

Accepted Solutions
MVP
MVP

Re: Include only these Dimensions in Set Analysis

Try something like

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

6 Replies
MVP
MVP

Re: Include only these Dimensions in Set Analysis

Try something like

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

sfatoux72
Valued Contributor

Re: Include only these Dimensions in Set Analysis

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 ($)

lubicz99
Valued Contributor

Re: Include only these Dimensions in Set Analysis

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?

sfatoux72
Valued Contributor

Re: Include only these Dimensions in Set Analysis

Yes, without problem

lubicz99
Valued Contributor

Re: Include only these Dimensions in Set Analysis

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.

sfatoux72
Valued Contributor

Re: Include only these Dimensions in Set Analysis

You could find information about this solution here:

Community Browser