topic Re: Sum and date on date difference in QlikView

Sum and date on date difference

Mon, 28 Dec 2015 13:20:12 GMT

Hi all,

I have table that looks like this:

I am trying to sum up the goals that each team scored on the latest date (max date). I've created a variable

vMaxDate = (Date(Max(Date)),Team). I've tried 2 expressions and it keeps selecting the largest goals scored. These are my expressions:

(aggr(SUM(if(Date=$(=vMaxDate), Goals,0)),Team))

(if(Date=$(=vMaxDate), Goals,0))

I want my output to look like this:

I also need to calculate a sequential difference based on the date i.e. :

sunny_talwar — Mon, 28 Dec 2015 15:26:02 GMT

Try this in a straight table

Dimension: Team

Expression1: =Date(Max(Date))

Expression2: =FirstSortedValue(Aggr(Sum(Goals), Team, Date), -Aggr(Date, Team, Date))

sunny_talwar — Mon, 28 Dec 2015 15:28:41 GMT

For your second requirement create another straight table:

Dimension: Team, Division, Date

Expression1: Goals

Expression2: =Goals - Above(Goals)

Mon, 04 Jan 2016 06:32:01 GMT

Thank Sunny T. Works perfectly!