# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for
Did you mean:
Highlighted
Not applicable

## Able to create a measure using outputs of other measures?

Hi all,

I'm very new to Qlik, so apologies if I'm way away on this but here goes...

I have a database that manages leads. So far I have created the following measures:

I now need to calculate leads being investigated... which in theory is this calculation of the measures above:

Is it possible to do this calculation as a measure within in Qlik? Something like...

SUM(Count(LeadID)) MINUS (count({\$<[DateCompleted]-={"NULL"}>}  [DateCompleted]) MINUS (count({\$<[DateCancelled]-={"NULL"}>}  [DateCancelled]))

Or do I need to be approaching this in a different way?

Dan

1 Solution

Accepted Solutions
Highlighted

## Re: Able to create a measure using outputs of other measures?

May be this?

(Count(LeadID)) - (count({\$<[DateCompleted]-={"NULL"}>}  [DateCompleted]) - count({\$<[DateCancelled]-={"NULL"}>}  [DateCancelled]))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
5 Replies
Partner

## Re: Able to create a measure using outputs of other measures?

Hi,

If you label each expression, then you can use the label to create new expression.

Exp2=count({\$<[DateCompleted]-={"NULL"}>}  [DateCompleted])

Exp3=count({\$<[DateCancelled]-={"NULL"}>}[DateCancelled])

Exp4 = Exp1 - Exp2 - Exp3

Highlighted

## Re: Able to create a measure using outputs of other measures?

May be this?

(Count(LeadID)) - (count({\$<[DateCompleted]-={"NULL"}>}  [DateCompleted]) - count({\$<[DateCancelled]-={"NULL"}>}  [DateCancelled]))

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Not applicable

## Re: Able to create a measure using outputs of other measures?

Thank you Anil Babu Samineni, that worked! I just need to change the minus to a plus to add the the Date Completed and Date cancelled fields.

This has been a great help, thank you very much!

Highlighted
Not applicable

## Re: Able to create a measure using outputs of other measures?

Thank you Krishnapriya Arumugam for your reply. I wasn't able to set each expression within the measure, I could only set one?

I had the error 'garbage after 'Exp2''. Any idea what could cause this?

Many thanks

Highlighted
Partner

## Re: Able to create a measure using outputs of other measures?

Hi,

Hope you have created this expression in Script. Please end the expressions with Semicolon.