Aggregate chart function help

Wed, 26 Oct 2011 17:57:09 GMT

I have the following data set and want to show the percent of what percent of "AVG_HRS" "EFF_HRS" is for the selected period. In order to do this i need to add all values for AVG_HRS where TAT_INDICATOR is not equal to 'NA' for the selected date range and devide that by the sum value of EFF HRS for the same date range where TAT_INDICATOR is not equal to NA. I have been unable to acheive this. Can someone help please?

The numberical formula should be 70.3/62.25 = 113%

TAT_INDICATOR	WO_NO	EFF_HRS	AVG_HRS
HIGH	110467	17.5	21.9
CONTROLLED	111945	22	24.2
LOW	113943	22.75	24.2
NA	113035	6
NA	114524	1

Aggregate chart function help

Wed, 26 Oct 2011 18:59:35 GMT

Just a If statement

=sum ( if(TAT_INDICATOR <>'NA' , AVG_HRS ) ) / sum ( if(TAT_INDICATOR <>'NA' , EFF_HRS ) )

regards

Aggregate chart function help

Thu, 27 Oct 2011 11:43:32 GMT

Thanks JJ that worked out perfectly. I was overcomplicating it.

topic Aggregate chart function help in QlikView

Aggregate chart function help

Aggregate chart function help

Aggregate chart function help