Discussion Board for collaboration related to QlikView App Development.
=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?
Try something like
Count( {1<[Name] = $::Name, [Group Number] = $::[Group Number] >} FieldName)
Try something like
Count( {1<[Name] = $::Name, [Group Number] = $::[Group Number] >} FieldName)
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 ($)
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?
Yes, without problem
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.
You could find information about this solution here: