Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Partner
Partner

Aggr in calculated dimension not working

Hello, I'm trying to set up three calculated dimensions that I can use in a cyclic group for a chart. Each calculated dimension should show the selected values of the same field but for different alternate states. Below is my current expression:

=aggr(only({state1} [Entity Name]), [Entity Name])

=aggr(only({state2} [Entity Name]), [Entity Name])

=aggr(only({state3} [Entity Name]), [Entity Name])


I added this cyclic group to a bar chart and set the expression to =1. All I want to see right now is the dimensions change based on the cyclic. However, the only value that I'm getting is '-'. Any ideas of what is happening here?

1 Solution

Accepted Solutions
Partner
Partner

Re: Aggr in calculated dimension not working

Wait, nevermind. I figured out my problem. I had an expression on the Background Color of the expression that was causing it to fail. Removing it got it to work.

View solution in original post

4 Replies

Re: Aggr in calculated dimension not working

Seems to be working for me here (PFA)

Partner
Partner

Re: Aggr in calculated dimension not working

Huh, that's interesting. I compared yours to mine and I can't see any difference, which makes me believe that it is my data that is causing the problem. I added the aggr() expression to a text object and it returned the correct value when one value was selected, but would show '-' when I had two or more values selected. Can you think of any reason within my data set that would cause that? The [Entity Name] field contains unique values.

Partner
Partner

Re: Aggr in calculated dimension not working

Wait, nevermind. I figured out my problem. I had an expression on the Background Color of the expression that was causing it to fail. Removing it got it to work.

View solution in original post

Partner
Partner

Re: Aggr in calculated dimension not working

While on this topic, do you know if it is possible to set it up so that lassoing on the bar chart will cause the selection to be in the current alternate state specified on the cyclic?