topic Re: Layout in QlikView https://community.qlik.com/t5/QlikView/Layout/m-p/1005975#M527728 <HTML><HEAD></HEAD><BODY><P>Try Avg(Aggr(YourExpression,Month)) in the textbox.</P></BODY></HTML> Wed, 23 Sep 2015 07:15:33 GMT simenkg 2015-09-23T07:15:33Z Layout https://community.qlik.com/t5/QlikView/Layout/m-p/1005974#M527727 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have one bar chart and text object. both having same expression, but bar chart shows by Month dimention.</P><P>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?</P></BODY></HTML> Wed, 23 Sep 2015 07:12:55 GMT https://community.qlik.com/t5/QlikView/Layout/m-p/1005974#M527727 2015-09-23T07:12:55Z Re: Layout https://community.qlik.com/t5/QlikView/Layout/m-p/1005975#M527728 <HTML><HEAD></HEAD><BODY><P>Try Avg(Aggr(YourExpression,Month)) in the textbox.</P></BODY></HTML> Wed, 23 Sep 2015 07:15:33 GMT https://community.qlik.com/t5/QlikView/Layout/m-p/1005975#M527728 simenkg 2015-09-23T07:15:33Z