Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Layout


Hi,

I have one bar chart and text object. both having same expression, but bar chart shows by Month dimention.

When i click on one month values for both bar chart and text object is same, But when i select two month, it should show average of bar chart two month values to text object. For example in my bar chart aug value is 98.82% and Sep value is 99.17% in text object it should display average of two month .ie 98.995. but it shows 99.33. can you suggest me solution for this?

Tags (1)
1 Reply
bwisenosimenkg
Valued Contributor

Re: Layout

Try Avg(Aggr(YourExpression,Month)) in the textbox.

Community Browser