topic Create In Year Selection in QlikView https://community.qlik.com/t5/QlikView/Create-In-Year-Selection/m-p/174875#M43527 <HTML><HEAD></HEAD><BODY><P>Im trying to create an Inyear selection option. The idea is that user can select Financial Year and then either full_year or in_year.</P><P>I have one date in my data and my financial year starts 1st April.</P><P>I've not used the new set Analysis but it looks like this could be the trick?</P><P>Thus Full year is the sum of all totals where date is within the financial year.</P><P>In year is project total / 12 and sum of project where months fall into this financial year.</P><P></P><P>eg. 01/12/09 - project A - 15,000</P><P>Full year = 15,000 for 2009/10 financial year</P><P>In Year = (15,000 / 12 ) * 4 ( as only 4 months are in 2009/10 financial year and 8 months in next financial year )</P><P>= 5000 09/10 and 10,000 10/11</P><P></P><P>Is this possible ?</P></BODY></HTML> Wed, 10 Mar 2010 16:14:50 GMT 2010-03-10T16:14:50Z Create In Year Selection https://community.qlik.com/t5/QlikView/Create-In-Year-Selection/m-p/174875#M43527 <HTML><HEAD></HEAD><BODY><P>Im trying to create an Inyear selection option. The idea is that user can select Financial Year and then either full_year or in_year.</P><P>I have one date in my data and my financial year starts 1st April.</P><P>I've not used the new set Analysis but it looks like this could be the trick?</P><P>Thus Full year is the sum of all totals where date is within the financial year.</P><P>In year is project total / 12 and sum of project where months fall into this financial year.</P><P></P><P>eg. 01/12/09 - project A - 15,000</P><P>Full year = 15,000 for 2009/10 financial year</P><P>In Year = (15,000 / 12 ) * 4 ( as only 4 months are in 2009/10 financial year and 8 months in next financial year )</P><P>= 5000 09/10 and 10,000 10/11</P><P></P><P>Is this possible ?</P></BODY></HTML> Wed, 10 Mar 2010 16:14:50 GMT https://community.qlik.com/t5/QlikView/Create-In-Year-Selection/m-p/174875#M43527 2010-03-10T16:14:50Z