sum and aggr

[lionel_t]

Hello,

  I don't know how to combine sum and aggr function in my set analysis expression.

  I need help to find the right expression syntax to get the correct result.

   I give an exemple of my chart expression ( t6 ).

Sum({<

     D_Date_Histo={"$(=

  Aggr(

  only(date(date(D_Date_Time+State_Day_Value)&' '&MakeTime(State_Time_Value),'DD/MM/YYYY hh'))

  ,D_Date_Time

  )               

                  )"}

     >} D_LastPRVValue)

[ecolomer]

Hi, attached you have an example.

[ecolomer]

You can change Avg with Sum, because are same type of function

[ecolomer]

See this:

https://community.qlik.com/docs/DOC-12703