Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
lionel_t
Contributor
Contributor

sum and aggr

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)

3 Replies
ecolomer
Master II
Master II

Hi, attached you have an example.

ecolomer
Master II
Master II

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