topic Re: max function in a plot of average in QlikView https://community.qlik.com/t5/QlikView/max-function-in-a-plot-of-average/m-p/844681#M1007712 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>avg({1&lt; <SPAN style="font-size: 13.3333330154419px;">[week(data)] = {"$(=</SPAN>Max([week(data)]))"} &gt;} [<SPAN style="font-size: 13.3333330154419px;">avg_sum_of_sales</SPAN>])</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 12 May 2015 18:06:30 GMT marcus_sommer 2015-05-12T18:06:30Z max function in a plot of average https://community.qlik.com/t5/QlikView/max-function-in-a-plot-of-average/m-p/844680#M1007711 <HTML><HEAD></HEAD><BODY><P>Hello, community!</P><P>I have a dataset with fields, such as: data, week(data), avg_sum_of_sales.</P><P>I want to create a text_box which contains average sum of sales per LAST week (max(week(data)) . I try to make such expression:</P><P> avg({1&lt;<SPAN style="font-size: 13.3333330154419px;">[week(data)]=</SPAN>Max([week(data)]))&gt;}[avg(<SPAN style="font-size: 13.3333330154419px;">avg_sum_of_sales</SPAN>)]). Whats wrong with that and how to make it right?</P><P></P><P>Thanks in advance!</P><P>Marina</P></BODY></HTML> Tue, 12 May 2015 16:06:29 GMT https://community.qlik.com/t5/QlikView/max-function-in-a-plot-of-average/m-p/844680#M1007711 2015-05-12T16:06:29Z Re: max function in a plot of average https://community.qlik.com/t5/QlikView/max-function-in-a-plot-of-average/m-p/844681#M1007712 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>avg({1&lt; <SPAN style="font-size: 13.3333330154419px;">[week(data)] = {"$(=</SPAN>Max([week(data)]))"} &gt;} [<SPAN style="font-size: 13.3333330154419px;">avg_sum_of_sales</SPAN>])</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 12 May 2015 18:06:30 GMT https://community.qlik.com/t5/QlikView/max-function-in-a-plot-of-average/m-p/844681#M1007712 marcus_sommer 2015-05-12T18:06:30Z Re: max function in a plot of average https://community.qlik.com/t5/QlikView/max-function-in-a-plot-of-average/m-p/844682#M1007713 <HTML><HEAD></HEAD><BODY><P>Thanks a lot!!! </P></BODY></HTML> Wed, 13 May 2015 08:43:31 GMT https://community.qlik.com/t5/QlikView/max-function-in-a-plot-of-average/m-p/844682#M1007713 2015-05-13T08:43:31Z