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: 
Not applicable

Ignore chart dimension in second expression

Hi all,

as obect i need to ignore one dimension for the second expression of my stacked bar chart.

dimension:

time

cities

expressions:

count(people_city)

avg(people_all the cities) --> must ignore the cities dimension

Attached the chart structure without the second expression, i would like to represent the value of avg(people_all the cities) on top of every stacked bar.

How can i realize it?

Tx you!!!

6 Replies
MK_QSL
MVP
MVP

avg({<Cities = >}people_all the cities)

tresesco
MVP
MVP

May be like:

Avg( Total <CityDim> YourPeopleDim)

Not applicable
Author

refer to this case, I think it should be

Avg( Total <TimeDim> people_city)

Not applicable
Author

I tried both the ways,

but i lost dimension also for the first expression (attached the jpg)..

Where is my mistake?

MK_QSL
MVP
MVP

Can you upload your sample apps?

Not applicable
Author

It's a bit hard to extract the code.

The problem is that in the second expression i already have a set analysis with temporal filter, so now i should have

avg({<Cities = > * <temporal filter>}people_all the cities)

but in this way the city filter doesn't work and i continue to see all the city.