Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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