topic Multiplying Expression in QlikView

Multiplying Expression

Fri, 22 Aug 2014 17:18:14 GMT

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?

Re: Multiplying Expression

nagaiank — Fri, 22 Aug 2014 17:40:25 GMT

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.

Re: Multiplying Expression

Fri, 22 Aug 2014 18:24:50 GMT

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