topic Re: Set Analysis with Only and Aggr in QlikView

Set Analysis with Only and Aggr

lampshadedreams — Thu, 20 Jun 2019 14:51:08 GMT

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.

Re: Set Analysis with Only and Aggr

sunny_talwar — Thu, 20 Jun 2019 15:12:12 GMT

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

Re: Set Analysis with Only and Aggr

lampshadedreams — Thu, 20 Jun 2019 15:18:26 GMT

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?

Re: Set Analysis with Only and Aggr

sunny_talwar — Thu, 20 Jun 2019 15:21:22 GMT

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.

Re: Set Analysis with Only and Aggr

lampshadedreams — Thu, 20 Jun 2019 15:22:00 GMT

ok thank you