Discussion Board for collaboration on QlikView Layout & Visualizations.
I am trying to get the latest value every month and plot it in a chart against time.
My data looks like the below,
And i am aware that Sum cannot be used as it is a snapshot of the weekly Stock. I tried using Only , but missing something to complete it. Please help. Attached the sample application here.
Thanks in advance.
May be this:
FirstSortedValue(Aggr(Sum(Stock), Date), -Aggr(Day, Date))
Or if you want to get the stock on the last dates of a month per city:
=Sum(Aggr( FirstSortedValue(Stock,-Date),Country, City,Monthname))
edit: Monthname is a field created in the script