Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
christian_nac
Contributor
Contributor

Count out of limits in a range of dates, control chart

Dear All,

I need to display count the data that arer out of the limits in the selected time period, i have this:

control chart

chart control.JPG

table

i have the expression to know wich ones are out of range:

if( ([S/F] > vLSGralTAD) or ( [S/F] < vLIGralTAD), [S/F],0)

table chart.JPG

Where i expect how many data are out, in and calculate de percentage of those who are inside de bounds.

Out: 6

In: 16

Total: 22

% In:  72.7 %

Any one can help me to this set expression syntax.

Following is the expression I'm using for count the data  where it is not showing any error in expression view but no data returned.

For count the data that are in the limits:

Count(   {<if( [S/F] > vLSGralTAD or [S/F] < vLIGralTAD),0,1)>} DISTINCT{<fecha_ex={"<=$(vFechaFinal)>=$(vFechaInicial)"} >} )

1 Reply
christian_nac
Contributor
Contributor
Author

someone who can support me?