topic Re: Re: Ignore chart dimension in second expression in QlikView

Ignore chart dimension in second expression

Wed, 09 Apr 2014 09:49:05 GMT

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!!!

Re: Ignore chart dimension in second expression

MK_QSL — Wed, 09 Apr 2014 09:52:45 GMT

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

Re: Ignore chart dimension in second expression

tresB — Wed, 09 Apr 2014 09:52:49 GMT

May be like:

Avg( Total <CityDim> YourPeopleDim)

Re: Ignore chart dimension in second expression

Wed, 09 Apr 2014 10:08:37 GMT

refer to this case, I think it should be

Avg( Total <TimeDim> people_city)

Re: Re: Ignore chart dimension in second expression

Wed, 09 Apr 2014 10:15:13 GMT

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

MK_QSL — Wed, 09 Apr 2014 10:20:17 GMT

Can you upload your sample apps?

Re: Re: Ignore chart dimension in second expression

Wed, 09 Apr 2014 10:37:37 GMT

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.