Problem with complex output requirement

[#1]

Hi,

Perhaps there is an easy way to do this, but I am new to Qlikview & still on the free version.

So was hoping someone could help me out. I have a table with documents & values as per the excel file attached.

What I need as an output is the consolidated based on a seperate set of values - fiscal periods for the year - sample output also attached.

Would highly appreciate all help...

Regards,

A.

[qliksus]

Hi

try this 

sum({<open_till={''}>} DC_value) + sum(if( Due_period>=Open_till and Due_period<=Open_from , DC_value))