Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Creating a new measure based on 2 existing measures

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....

1 Solution

Accepted Solutions
don_qlikview
Contributor

Re: Creating a new measure based on 2 existing measures

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

4 Replies
phaneendra_kunc
Valued Contributor III

Re: Creating a new measure based on 2 existing measures

have you tried creating a new measure like below?

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

don_qlikview
Contributor

Re: Creating a new measure based on 2 existing measures

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

Not applicable

Re: Creating a new measure based on 2 existing measures

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

Not applicable

Re: Creating a new measure based on 2 existing measures

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

Community Browser