Qlik Community

Ask a Question

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: 
kunkumnaveen
Specialist
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))))

 

Capture.PNG

 

 

What am i missing in above KPI expression ?

 

Thanks

 

1 Solution

Accepted Solutions
sunny_talwar

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))))

View solution in original post

5 Replies
kunkumnaveen
Specialist
Specialist
Author

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

Any suggestions form you guys

 

Thanks

kunkumnaveen
Specialist
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

sunny_talwar

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))))

View solution in original post

kunkumnaveen
Specialist
Specialist
Author

Thanks Sunny , Its Working 

sunny_talwar

Awesome!!