Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshp90
Creator III
Creator III

Expression is not populating for all project numbers

Hello, 

I have a table as shown below

123.PNG

 

 

 

 

 

 

 

 

 

 

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

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar

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%')

View solution in original post

2 Replies
sunny_talwar

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%')

bhaveshp90
Creator III
Creator III
Author

thank you @sunny_talwar  for your valuable time and help