topic Allocations in QlikView https://community.qlik.com/t5/QlikView/Allocations/m-p/294061#M109083 <HTML><HEAD></HEAD><BODY><P>Is it possible to do allocations in Qlikview?&nbsp; I am trying to create a pivot chart in which I values from an expression are then utilized by another dimension.&nbsp; Like this</P><P></P><P>Dimension,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>All Level&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FullTime FTEs:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 70 (this is calculated to come up with this number)</P><P>Professional&nbsp;&nbsp;&nbsp;&nbsp; FullTime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35 (based on allocation from the All Level)</P><P>Technical&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FullTime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 (based on allocation from the All Level)</P><P>Managerial&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FullTime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10 (based on allocation from the All Level)</P><P>Clerical&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FullTime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp; (based on allocation from the All Level)</P><P></P><P></P><P>Basically, all of the data is loaded at the All level and then allocated out based on factors and calculations.</P><P></P><P></P><P></P><P></P><P></P><P>Any insight is always appreciated.</P><P></P><P></P><P>Joe</P></BODY></HTML> Wed, 20 Jul 2011 13:11:03 GMT 2011-07-20T13:11:03Z Allocations https://community.qlik.com/t5/QlikView/Allocations/m-p/294061#M109083 <HTML><HEAD></HEAD><BODY><P>Is it possible to do allocations in Qlikview?&nbsp; I am trying to create a pivot chart in which I values from an expression are then utilized by another dimension.&nbsp; Like this</P><P></P><P>Dimension,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expression,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P>All Level&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FullTime FTEs:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 70 (this is calculated to come up with this number)</P><P>Professional&nbsp;&nbsp;&nbsp;&nbsp; FullTime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 35 (based on allocation from the All Level)</P><P>Technical&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FullTime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20 (based on allocation from the All Level)</P><P>Managerial&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FullTime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10 (based on allocation from the All Level)</P><P>Clerical&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FullTime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp; (based on allocation from the All Level)</P><P></P><P></P><P>Basically, all of the data is loaded at the All level and then allocated out based on factors and calculations.</P><P></P><P></P><P></P><P></P><P></P><P>Any insight is always appreciated.</P><P></P><P></P><P>Joe</P></BODY></HTML> Wed, 20 Jul 2011 13:11:03 GMT https://community.qlik.com/t5/QlikView/Allocations/m-p/294061#M109083 2011-07-20T13:11:03Z