Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thefish
Contributor
Contributor

Correct Value for Rows not matching KPI

I am designing a control table for my company and coming acorss an odd issue. 

 

The table has the following structure: 

1 dimension (we'll call it [Group])

A couple of measures most of which are master measures and 1 new measure (Days out of control)

The  days out of control measure works fine if not in the table and is in a KPI (It shows the number of days beneath the LCL)

 

However, when we move it into the table, I hit an odd error. the value of this days out of control is an error. 

 

The expression is listed below (modified to hide company data) 

 

SUM(AGGR(IF($(vValue)<$(vLowerLimit),1,0), [Date]))

 

 

I have tried fixing my =  signs in variables to find the solution but to no avail. 

 

Please help! 

 

Thanks in advance,

 

Fish

Labels (2)
0 Replies