Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiplying Expression

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?

2 Replies
nagaiank
Specialist III
Specialist III

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.

Not applicable
Author

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