Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Partner
Partner

Bottom 20% count

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

 

 

 

 

 

Labels (1)
1 Reply
Partner
Partner

Any suggestion on this plz