Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Grouped variables in graphs

Hi,

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).

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 ).

Does anyone have any good solutions?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

FirstSortedValue([Stock level],-Date). See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

FirstSortedValue([Stock level],-Date). See attached qvw.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks!

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

=FirstSortedValue(distinct Aggr(sum([Stock level]), Date), -Date)