Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Allocations

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

0 Replies