Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to calculate sum of two different fields from two different fields -
sum needs to be calculated in the third table.
field 1 - is sum(x+y+z) as field1
fields 2 - is sum (a+b+c) as field2
in another table i need to calculate field3 which would be field1+field2
Please help
You will need to somehow bring all the fields in one table to do this in the script. To bring them together, you can do join, mapping or lookup
Better if you can provide a sample document or your data model. screenshot.
attached file to original post
look into "ChangeHere" tab - for now I fixed it in the table name "Working" - I commented it for now , so that you can take a look
but I actually need to make it work using tables "Current" , "Two" - and calculate Field_1 from "Current" table, Field_2 from "Two" table.
And calculate Sum in the other table.
Please take a look
I'm bringing all the fields by concatenating table "current" and table "two"
But somehow in the final table I'm not getting any values
Instead of the "+" operator, use the RangeSum() function to sum multiple fields. See if that makes a difference in your case.
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
Thankyou Rob!
Did RangeSum() fix the problem?
