Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Aggregate chart function help

    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
HIGH11046717.521.9
CONTROLLED1119452224.2
LOW11394322.7524.2
NA1130356
NA1145241
Tags (3)
1 Solution

Accepted Solutions
Not applicable

Aggregate chart function help

hi

Just a If statement

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

regards

JJ

2 Replies
Not applicable

Aggregate chart function help

hi

Just a If statement

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

regards

JJ

Not applicable

Aggregate chart function help

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

Community Browser