# 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
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!!