Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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?

1 Reply
simenkg
Specialist
Specialist

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