Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
In the script you can write (Job.StopAmountBillable)-(Job.StopAmountInvoiced) as [amount not billed]
have you tried creating a new measure like below?
sum(Job.StopAmountBillable)-sum(Job.StopAmountInvoiced)
In the script you can write (Job.StopAmountBillable)-(Job.StopAmountInvoiced) as [amount not billed]
Thank you! I didn't know you could have the subtraction in there New to Qlik and have no scripting background...learning curve!
Thank you! This is something I'll want to measure moving forward!