topic Re: Expression is not populating for all project numbers in QlikView

Expression is not populating for all project numbers

bhaveshp90 — Sat, 16 Nov 2024 03:49:27 GMT

Hello,

I have a table as shown below

Here the POC is correct which is 74%, but POC Expression is not populating for all rows (as shown above) what is wrong in my expression here? Attached is file for reference.

=
num(
aggr((Sum({1<[SCH Task Discipline],[ORA DAY VERSION]={">=$(vCurrentMonthStart)<=$(vCurrentMonthEnd)"}>}[ORA Actual])
/
Sum({1<[SCH Task Discipline],[ORA DAY VERSION]={">=$(vCurrentMonthStart)<=$(vCurrentMonthEnd)"}>}[ORA Projected])
), [ORA Project Number])
,'##0%')

thanks

Re: Expression is not populating for all project numbers

sunny_talwar — Wed, 17 Apr 2019 16:55:45 GMT

Try this

=
num(
aggr(NODISTINCT(Sum({1<[SCH Task Discipline],[ORA DAY VERSION]={">=$(vCurrentMonthStart)<=$(vCurrentMonthEnd)"}>}[ORA Actual])
/
Sum({1<[SCH Task Discipline],[ORA DAY VERSION]={">=$(vCurrentMonthStart)<=$(vCurrentMonthEnd)"}>}[ORA Projected])
), [ORA Project Number])
,'##0%')

Re: Expression is not populating for all project numbers

bhaveshp90 — Wed, 17 Apr 2019 17:13:38 GMT

thank you @sunny_talwar for your valuable time and help