Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
alexandernatale
Creator II
Creator II

Sum value at start date

Hello,

my goal is to do the sum of a value field (TIR) ​​only for those dates that are beginning of the month

=sum({<Data{'$(=monthstart(Data))'}>} TIR)

where am i wrong?

14 Replies
alexandernatale
Creator II
Creator II
Author

I try the formula but the result is the same..all the months report also the value at start of month.. 😞

 

tresesco
MVP
MVP

With me:

tresesco_0-1590765654360.png

 

alexandernatale
Creator II
Creator II
Author

=Sum( if(Day(Data)=( Aggr(NODISTINCT Day(Max(Data)), num(Month(Data)))), TIR))-Sum( if(Day(Data)=1, TIR))

 

I tried to insert this variation to don't touch the script editor but the result is not consider the initial data.. 

 

I think that the solution is to create a field "Month" in the table...although this slightly changes the snowflake structure with Syntetic keys..

tresesco
MVP
MVP

Aggr() can't work on calculated dimension but field created in the script.

alexandernatale
Creator II
Creator II
Author

@tresesco thank you so much for your patience! Have a good day!