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.

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

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 :  

(Sum(TOTAL d_OP)*20/100),sum(d_OP),0)


Expression %:

(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

Any suggestion on this plz