topic Re: Split Variable Forecasting in QlikView https://community.qlik.com/t5/QlikView/Split-Variable-Forecasting/m-p/1151260#M376186 <HTML><HEAD></HEAD><BODY><P>Forgive me for being confused. I put the screenshots into the question. The only variables that I am pulling in are Project, Invoice Date and Invoice Amount. </P></BODY></HTML> Tue, 26 Jul 2016 20:47:21 GMT 2016-07-26T20:47:21Z Split Variable Forecasting https://community.qlik.com/t5/QlikView/Split-Variable-Forecasting/m-p/1151258#M376184 <HTML><HEAD></HEAD><BODY><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132599_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Hey guys! I am working on a report that show invoiced amounts by year for a certain project. Currently my output is above. I need to break this up such that it look like this:</P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/132600_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P>Forgive my bad excel skills..</P><P></P><P></P><P>A. Is this possible?</P><P>B. If so- can I make it rolling based on current year?</P></BODY></HTML> Tue, 26 Jul 2016 19:59:37 GMT https://community.qlik.com/t5/QlikView/Split-Variable-Forecasting/m-p/1151258#M376184 2016-07-26T19:59:37Z Re: Split Variable Forecasting https://community.qlik.com/t5/QlikView/Split-Variable-Forecasting/m-p/1151259#M376185 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>can you share sample data / app to demonstrate</P></BODY></HTML> Tue, 26 Jul 2016 20:41:28 GMT https://community.qlik.com/t5/QlikView/Split-Variable-Forecasting/m-p/1151259#M376185 vinieme12 2016-07-26T20:41:28Z Re: Split Variable Forecasting https://community.qlik.com/t5/QlikView/Split-Variable-Forecasting/m-p/1151260#M376186 <HTML><HEAD></HEAD><BODY><P>Forgive me for being confused. I put the screenshots into the question. The only variables that I am pulling in are Project, Invoice Date and Invoice Amount. </P></BODY></HTML> Tue, 26 Jul 2016 20:47:21 GMT https://community.qlik.com/t5/QlikView/Split-Variable-Forecasting/m-p/1151260#M376186 2016-07-26T20:47:21Z Re: Split Variable Forecasting https://community.qlik.com/t5/QlikView/Split-Variable-Forecasting/m-p/1151261#M376187 <HTML><HEAD></HEAD><BODY><P>Hi Robyn,</P><P>You Need to use ValueList() like this</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/132597_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/132598_pastedImage_1.png" style="max-height: 900px; max-width: 1200px;" /></P><P>See attachment.</P><P>Regards,</P><P>Antonio</P></BODY></HTML> Tue, 26 Jul 2016 20:55:23 GMT https://community.qlik.com/t5/QlikView/Split-Variable-Forecasting/m-p/1151261#M376187 antoniotiman 2016-07-26T20:55:23Z