# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Contributor

## Modify measure formula to show distinct value (only if same item NO)

My measure formula:

Sum(distinct(if(Gate='Gate D' and Status='Completed' and Temp='Task_17'and

,[SOW Value])))

# How to modify my formula in order to get 19,230,824 ?

1 Solution

Accepted Solutions
Contributor II

## Re: Modify measure formula to show distinct value (only if same item NO)

Try this

sum(aggr(Sum(distinct(if(Gate='Gate D' and Status='Completed' and Temp='Task_17'and

,[SOW Value]))),SR No))

3 Replies
Contributor II

## Re: Modify measure formula to show distinct value (only if same item NO)

Try this

sum(aggr(Sum(distinct(if(Gate='Gate D' and Status='Completed' and Temp='Task_17'and

,[SOW Value]))),SR No))

Valued Contributor II

## Re: Modify measure formula to show distinct value (only if same item NO)

Hi,

can you  try this

=Sum(

{<

>}

[SOW Value])

or

=Aggr(

Sum(

{<

>}

[SOW Value])

,No)

Contributor

## Re: Modify measure formula to show distinct value (only if same item NO)

Thanks Raman. Its works.