Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kunkumnaveen
Specialist
Specialist

How to write the expression in KPI

Hello All,

I am trying to show count of distinct bottom 20% codes in a KPI

same i have tried and succeed in combo chart but not able to show in KPI object

In Combo chart

Dimension : Code

Expression :

If(RangeSum(Above(Sum(d_OP),0,RowNo()))
<
(Sum(TOTAL d_OP)*20/100),sum(d_OP),0)

 

Expression %:

If(RangeSum(Above(Sum(d_OP),0,RowNo()))
<
(Sum(TOTAL d_OP)*20/100),(sum(d_OP)/sum(total d_OP))*100,0)

 

sorting : Code--->Expression:sum(d_OP) --->Ascending

 

But for KPI i am confuse how to write a expression which sorts and get bottom 20 % codes count

 

Attaching the out put file of my Bottom 20 % Combo chart where distinct codes count is 535.

Need to show the same value in KPI

3 Replies
kunkumnaveen
Specialist
Specialist
Author

Any suggestion on above requirement ...

kunkumnaveen
Specialist
Specialist
Author

Still couldn't able to find the solution for the above requirement .Any help would be appreciated

Brett_Bleess
Former Employee
Former Employee

Can you please confirm whether this is QlikView or Qlik Sense you are using, believe it is Sense, but I wanted to be sure before I move your post to the correct product forum, as you posted to QlikView, but I can move it for you, so no need to repost yourself, just let me know if you are using Sense or not, and if so, I can get it moved later today or tomorrow for you.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.