Is it possible to do allocations in Qlikview? I am trying to create a pivot chart in which I values from an expression are then utilized by another dimension. Like this
Dimension, Expression, Value
All Level FullTime FTEs: 70 (this is calculated to come up with this number)
Professional FullTime 35 (based on allocation from the All Level)
Technical FullTime 20 (based on allocation from the All Level)
Managerial FullTime 10 (based on allocation from the All Level)
Clerical FullTime 5 (based on allocation from the All Level)
Basically, all of the data is loaded at the All level and then allocated out based on factors and calculations.
Any insight is always appreciated.
Joe