topic How to write the expression in KPI in QlikView

How to write the expression in KPI

kunkumnaveen — Wed, 22 Jan 2020 04:33:25 GMT

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

Re: How to write the expression in KPI

kunkumnaveen — Wed, 22 Jan 2020 09:33:39 GMT

Any suggestion on above requirement ...

Re: How to write the expression in KPI

kunkumnaveen — Wed, 22 Jan 2020 12:55:27 GMT

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

Re: How to write the expression in KPI

Brett_Bleess — Wed, 19 Feb 2020 16:57:05 GMT

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