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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
thefish
Contributor
Contributor
‎2019-07-29 05:38 PM

Variable Correct before going in table, but wrong in each row

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

379 Views
0 Likes
0 Replies