Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

Any suggestion on above requirement ...

Highlighted
Specialist
Specialist

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

Highlighted
Digital Support
Digital Support

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.