Set Analysis

[fatihsahin]

Hi community,

I need a set analysis statemet which selects all available months within a Fiscal Year until the selected months and builds the sum of a value.

Regards and thanks

[Gysbert_Wassenaar]

See

• QlikCommunity Tip: How to get answers to your post?
• Accumulations
• The Above Function
• The As-Of Table
• Calculating rolling n-period totals, averages or other aggregations‌

[sunny_talwar]

Can you share a sample?

[swuehl]

So you have a Fiscal Year and a single Month selected?

Then try something like

=Sum({<MonthField = {"<=$(=Max(MonthField))"}>} Value)

MonthField should have a numeric representation, like Month() QV function is generating a dual value by default.