Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Ignore chart dimension in second expression

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

MVP
MVP

Re: Ignore chart dimension in second expression

May be like:

Avg( Total <CityDim> YourPeopleDim)

Not applicable

Re: Ignore chart dimension in second expression

refer to this case, I think it should be

Avg( Total <TimeDim> people_city)

Not applicable

Re: Re: Ignore chart dimension in second expression

I tried both the ways,

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

Where is my mistake?

Re: Ignore chart dimension in second expression

Can you upload your sample apps?

Highlighted
Not applicable

Re: Re: Ignore chart dimension in second expression

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.