Filter a KPI

Hi @andrea.lópez, have you tried to use a component filter in the olap table wit the requested pql, if you want to exclude the 5 and 6, then the would be FILTER COUNT(BKPF) NOT IN (5,6).

1) Right click on component (edit mode)

2) insert the filter condition in the 'Load script' part

Hope it helps

Hi, Javier.

Thank you for your answer but that filter doesn't work in my case.  

Also, in my case it isn't a general filter because I want to filter rows, not the general table.

Thank you again

oops, yes sorry 😶 , aggregations can not be use in filter statements, probably the PU_COUNT() will make it, what do you mean with filtering rows and not the general table?, do you mean a dynamic filter like the search ?

Hi Guys,

I am interested in the same topic, any update?

How can you filter based on a column in OLAP table? For ex. if I have 1 table with customers that meet a criteria and want to use the result to dynamically query another OLAP table.

Thanks for help

Dessy

Actually it is possible to apply a filter within a KPI!

Here an example to count all cases if failure category is D:

SUM(

CASE WHEN "Case table"."FAILURE CATEGORY" = 'D'

  THEN

    1.0 

  ELSE

    0.0 

END

)

Hi friends, could you please share if it has been resolved? I have the same case and I don't know how I can filter a table by a KPI that I have created 😭

Hi again,

Could you help me tell me how I can apply a filter with a KPI to an OLAP table (Component filter -> load script), Sheet (Setting -> Load script) or Number (Single KPI Components)?

I explain:

I have created a KPI that returns OK, KO or WARNING as a result. I want it to show me only the KOs. How can I do it?

For example, in OLAP table. Here I want it to show me only the KOs:

This is how I create the KPI:

CASE WHEN

(SUM (CASE WHEN "VBFA"."VBTYP_N" = 'J'

THEN 1

ELSE 0

END)) = 0

THEN 'WARNING'

WHEN (SUM (CASE WHEN "VBFA"."VBTYP_N" = 'J'

THEN 1

ELSE 0

END)) =

(SUM (CASE WHEN "VBFA"."VBTYP_N" = 'M'

THEN 1

ELSE 0

END))

THEN 'OK'

ELSE 'KO'

END

For example, in number (Single KPI Components)

I want to be able to later separate the total for each result into containers

Basically I want to add the KO, OK and WARNING

Thank you very much in advance.

Best regards,

Joel Luis