Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: How to combine Set Analysis with YTD Formula

Hi

This should work:

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


Let me know.


Thanks

Sabal

1 Reply
Not applicable

Re: How to combine Set Analysis with YTD Formula

Hi

This should work:

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


Let me know.


Thanks

Sabal

Community Browser