Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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
Highlighted

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

Highlighted
Creator III
Creator III

thank you @sunny_talwar  for your valuable time and help