topic Problem with complex output requirement in QlikView https://community.qlik.com/t5/QlikView/Problem-with-complex-output-requirement/m-p/316287#M116664 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Perhaps there is an easy way to do this, but I am new to Qlikview &amp; still on the free version.</P><P>So was hoping someone could help me out. I have a table with documents &amp; values as per the excel file attached.</P><P>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.</P><P></P><P>Would highly appreciate all help...</P><P></P><P>Regards,</P><P>A.</P></BODY></HTML> Wed, 05 Oct 2011 21:45:42 GMT 2011-10-05T21:45:42Z Problem with complex output requirement https://community.qlik.com/t5/QlikView/Problem-with-complex-output-requirement/m-p/316287#M116664 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Perhaps there is an easy way to do this, but I am new to Qlikview &amp; still on the free version.</P><P>So was hoping someone could help me out. I have a table with documents &amp; values as per the excel file attached.</P><P>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.</P><P></P><P>Would highly appreciate all help...</P><P></P><P>Regards,</P><P>A.</P></BODY></HTML> Wed, 05 Oct 2011 21:45:42 GMT https://community.qlik.com/t5/QlikView/Problem-with-complex-output-requirement/m-p/316287#M116664 2011-10-05T21:45:42Z Re: Problem with complex output requirement https://community.qlik.com/t5/QlikView/Problem-with-complex-output-requirement/m-p/316288#M116665 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>try this&nbsp; </P><P></P><P>sum({&lt;open_till={''}&gt;} DC_value) + sum(if( Due_period&gt;=Open_till and Due_period&lt;=Open_from , DC_value))</P><P></P></BODY></HTML> Thu, 06 Oct 2011 08:02:59 GMT https://community.qlik.com/t5/QlikView/Problem-with-complex-output-requirement/m-p/316288#M116665 qliksus 2011-10-06T08:02:59Z