Creating a new measure based on 2 existing measures

[#1]

How would I create a new measure based on two "defined" measures that are in my dataset.

The two defined measures as Job.Stop.AmountBillable and Job.StopAmountInvoiced

I want to create a calculation or measure that shows me the amount not billed, i.e. AmountBillable - AmountInvoiced.

In excel, I would do =(Job.StopAmountBillable)-(Job.StopAmountInvoiced)

I did some research on set analysis but I don't see how that could work....

[phaneendra_kunc]

have you tried creating a new measure like below?

sum(Job.StopAmountBillable)-sum(Job.StopAmountInvoiced)

[don_qlikview · Accepted solution]

In the script you can write (Job.StopAmountBillable)-(Job.StopAmountInvoiced) as [amount not billed]

[#4]

Thank you! I didn't know you could have the subtraction in there   New to Qlik and have no scripting background...learning curve!

[#5]

Thank you! This is something I'll want to measure moving forward!