Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stuhico09
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

[Date Modified.autoCalendar.YearMonth]>= (AddMonths(MonthStart(Today()-20),-11))

,[SOW Value])))


Value shown = 18,619,846



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


awd.PNG

cgcgc.PNG

1 Solution

Accepted Solutions
raman_rastogi
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

[Date Modified.autoCalendar.YearMonth]>= (AddMonths(MonthStart(Today()-20),-11))

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

3 Replies
raman_rastogi
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

[Date Modified.autoCalendar.YearMonth]>= (AddMonths(MonthStart(Today()-20),-11))

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

mdmukramali
Valued Contributor II

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

Hi,

can you  try this

=Sum(

{<

          Gate={'Gate D'} ,Status={'Completed'},Temp={'Task_17'},

           [Date Modified.autoCalendar.YearMonth]={">=AddMonths(MonthStart(Today()-20)-11)"}

>}

[SOW Value])


or


=Aggr(

Sum(

{<

          Gate={'Gate D'} ,Status={'Completed'},Temp={'Task_17'},

           [Date Modified.autoCalendar.YearMonth]={">=AddMonths(MonthStart(Today()-20)-11)"}

>}

[SOW Value])

,No)





stuhico09
Contributor

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

Thanks Raman. Its works.

Community Browser