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: 
Not applicable

How to combine Set Analysis with YTD Formula


Hello together,

i habe two formulas:

The first forumula isYTD

Sum({<Year=, Month=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>}€)

The second Formula is the Set Analysis

Sum({$<Nature={Actual}>}€)

How I get this two formulas in one formula.

Thank you

1 Solution

Accepted Solutions
Not applicable
Author

Hi

This should work:

Sum({$<Nature={Actual},Year=, Month=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>}€)


Let me know.


Thanks

Sabal

View solution in original post

1 Reply
Not applicable
Author

Hi

This should work:

Sum({$<Nature={Actual},Year=, Month=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>}€)


Let me know.


Thanks

Sabal