Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lampshadedreams
Contributor III
Contributor III

Set Analysis with Only and Aggr

Hi, I am trying to create a dimension for a chart so that only filters in my specified alternate state (Overview) affect it.

 

Here is the dimension I am trying to use in my straight table:

=aggr(Only({Overview<User = $::User, Month = $::Month>}Activity_ID),Activity_ID)

 

However, nothing populates in the table. The alternate state is called "Overview" and I want only the "User" and "Month" filters to impact the chart.

4 Replies
sunny_talwar

I think you should be driving the selection impact of filters from the expressions instead of dimension.... what is the expression in your chart?

lampshadedreams
Contributor III
Contributor III
Author

yeah I know, the problem is I have a lot of expressions (lots of columns in my straight table)

I was hoping there is a way to do this from the dimension formula. Is this possible?

sunny_talwar

As far as I know, you will need this set analysis in the expression to drive the results based on alternate state and User and Month from default state.

lampshadedreams
Contributor III
Contributor III
Author

ok thank you