topic Re: Grouped variables in graphs in QlikView https://community.qlik.com/t5/QlikView/Grouped-variables-in-graphs/m-p/659889#M1082899 <HTML><HEAD></HEAD><BODY><P>Thanks!</P><P></P><P>As I was creating the example I didn't think that there are more dimensions and thus [Stock level] is not one value but sum of stock values over products etc. But I think I figured it out correctly</P><P>=FirstSortedValue(distinct Aggr(sum([Stock level]), Date), -Date)</P></BODY></HTML> Thu, 26 Jun 2014 11:31:00 GMT 2014-06-26T11:31:00Z Grouped variables in graphs https://community.qlik.com/t5/QlikView/Grouped-variables-in-graphs/m-p/659887#M1082897 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have weekly level data that I have grouped date, month and year for drilling. As I look data at the month level I would like to see the net sum of flow variable (price change) and the latest value of month for stock variable (stock level).</P><P></P><P>I have attached an example data. E.g. for jan 13 I would like to have the value of 29.1.2013 not the average of month (as I have at the moment ).</P><P></P><P>Does anyone have any good solutions? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 26 Jun 2014 09:49:11 GMT https://community.qlik.com/t5/QlikView/Grouped-variables-in-graphs/m-p/659887#M1082897 2014-06-26T09:49:11Z Re: Grouped variables in graphs https://community.qlik.com/t5/QlikView/Grouped-variables-in-graphs/m-p/659888#M1082898 <HTML><HEAD></HEAD><BODY><P>FirstSortedValue([Stock level],-Date). See attached qvw.</P></BODY></HTML> Thu, 26 Jun 2014 10:38:36 GMT https://community.qlik.com/t5/QlikView/Grouped-variables-in-graphs/m-p/659888#M1082898 Gysbert_Wassenaar 2014-06-26T10:38:36Z Re: Grouped variables in graphs https://community.qlik.com/t5/QlikView/Grouped-variables-in-graphs/m-p/659889#M1082899 <HTML><HEAD></HEAD><BODY><P>Thanks!</P><P></P><P>As I was creating the example I didn't think that there are more dimensions and thus [Stock level] is not one value but sum of stock values over products etc. But I think I figured it out correctly</P><P>=FirstSortedValue(distinct Aggr(sum([Stock level]), Date), -Date)</P></BODY></HTML> Thu, 26 Jun 2014 11:31:00 GMT https://community.qlik.com/t5/QlikView/Grouped-variables-in-graphs/m-p/659889#M1082899 2014-06-26T11:31:00Z