topic Creating Years in Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Creating-Years-in-Calculated-Dimension/m-p/888107#M531482 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>There is a requirement that we need to chart which does forecasting for next 3 years. The problem is the values displayed in a bar chart for this forecasting is calculated dynamically based on various inputs and the data field from when the forecasting has to start is a user input. Based on a date that the user inputs how do I generate next 3 years in calculated dimension. </P><P>I know how to extract year from the date but how do I get in the dimension the next 3 years. </P><P></P><P>Request you guys for help.</P><P></P><P>Thanks in advance.</P><P></P><P>Madhu</P></BODY></HTML> Mon, 15 Jun 2015 00:42:53 GMT 2015-06-15T00:42:53Z Creating Years in Calculated Dimension https://community.qlik.com/t5/QlikView/Creating-Years-in-Calculated-Dimension/m-p/888107#M531482 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>There is a requirement that we need to chart which does forecasting for next 3 years. The problem is the values displayed in a bar chart for this forecasting is calculated dynamically based on various inputs and the data field from when the forecasting has to start is a user input. Based on a date that the user inputs how do I generate next 3 years in calculated dimension. </P><P>I know how to extract year from the date but how do I get in the dimension the next 3 years. </P><P></P><P>Request you guys for help.</P><P></P><P>Thanks in advance.</P><P></P><P>Madhu</P></BODY></HTML> Mon, 15 Jun 2015 00:42:53 GMT https://community.qlik.com/t5/QlikView/Creating-Years-in-Calculated-Dimension/m-p/888107#M531482 2015-06-15T00:42:53Z Re: Creating Years in Calculated Dimension https://community.qlik.com/t5/QlikView/Creating-Years-in-Calculated-Dimension/m-p/888108#M531483 <HTML><HEAD></HEAD><BODY><P>I found a solution for this. Thanks</P></BODY></HTML> Mon, 15 Jun 2015 03:47:36 GMT https://community.qlik.com/t5/QlikView/Creating-Years-in-Calculated-Dimension/m-p/888108#M531483 2015-06-15T03:47:36Z