Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Any suggestion on above requirement ...
Still couldn't able to find the solution for the above requirement .Any help would be appreciated
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