I am trying to split out the total amount of a line item by variable and fixed cost. I have a field name that lists whether and item is fixed or variable, however some are partially both. Is there a way for Qlikview to notice that say item 61803 is listed as 35% variable and 65% fixed and split the amount spent for 61803 by the respective amounts?
The column which specifies if the amount is fixed or variable, can specify (instead of F or V) the fraction fixed. If the value is completely fixed, this column (let me call it PctF) should have 1, 0 if it completely variable, any number in between, say 0.65, if partially fixed. Then
NagaianK The data was originally in that format. However, we wanted to see Fixed/Variable as a dimension. In addition the expressions we are using compares year to year. So I am looking for a way to split out the amounts into fixed and variable amounts in a single expression as opposed to 2 expressions like above
