# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Live chat with experts, bring your API Integration questions. June 15th, 10 AM ET. REGISTER TODAY
cancel
Showing results for
Search instead for
Did you mean:  Specialist

## How to write the expression in KPI

Hello All

I need to show the sum of below red colored rounded values in KPI

which is 9345+4915+3109+2172=

Dimension : base_model

Expression  In Table :

if(
rangesum(above(sum(d_OP)
/
sum(total d_OP),0,rowno()))<.80,sum(d_OP),0)

Expression In KPI (Tried but not worked 😞

sum(aggr(

if(
rangesum(above(sum(d_OP)
/
sum(total d_OP),0,rowno()))<.80,sum(d_OP),0)(base_model,(NUMERIC)))) What am i missing in above KPI expression ?

Thanks

1 Solution

Accepted Solutions  MVP

Try this

``````Sum(Aggr(

If(RangeSum(Above(Sum(d_OP)/Sum(TOTAL d_OP), 0, RowNo())) < 0.80, Sum(d_OP), 0)

, (base_model, (=Sum(d_OP), DESC))))``````
5 Replies  Specialist
Author

Still I couldn't find solution for the above requirement.

Any suggestions form you guys

Thanks  Specialist
Author

Any Suggestion on above requirement ,as i don't have any other source,so i m trying to find the solution over here  MVP

Try this

``````Sum(Aggr(

If(RangeSum(Above(Sum(d_OP)/Sum(TOTAL d_OP), 0, RowNo())) < 0.80, Sum(d_OP), 0)

, (base_model, (=Sum(d_OP), DESC))))``````  Specialist
Author

Thanks Sunny , Its Working  MVP

Awesome!! 