Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Fixed amount = Value * (PctF)
Variable Amount = Value * (1 - PctF)
Hope this helps.
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