Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
swuehl
MVP
MVP

Try something like

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

View solution in original post

6 Replies
swuehl
MVP
MVP

Try something like

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

sfatoux72
Partner - Specialist
Partner - Specialist

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

Anonymous
Not applicable
Author

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
Partner - Specialist
Partner - Specialist

Yes, without problem

Anonymous
Not applicable
Author

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
Partner - Specialist
Partner - Specialist

You could find information about this solution here: