topic Set Analysis in QlikView

Set Analysis

fatihsahin — Fri, 04 Dec 2015 13:44:14 GMT

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 — Fri, 04 Dec 2015 17:16:04 GMT

See

sunny_talwar — Fri, 04 Dec 2015 17:16:18 GMT

Can you share a sample?

swuehl — Fri, 04 Dec 2015 17:16:37 GMT

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.