Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
MVP
MVP

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)

Highlighted
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?

MVP
MVP

Re: Ignore chart dimension in second expression

Can you upload your sample apps?

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.


Community Browser