Skip to main content
Solved

Hello, can I filter to display only multiple attributes in an Olap table ?

  • February 15, 2023
  • 2 replies
  • 11 views
F
Level 4
Forum|alt.badge.img+6

Hello,

I need to display in an Olap Table only the “Codes” appearing twice or more (same code for different Building) : the user doesn’t want single “Code” but I am facing difficulties as I can’t put a count in my Case When statement.

 

Do you know any way to do this ? 

Thank you for your time !

Best regards,

François

 

 

Best answer by Anonymous

Hi François,

 

sounds like a problem you could solve with a PU_COUNT statement. You can use this in a filter statement to only get codes occurring twice or more. I can recommend checking the documentation, provides some good examples.

 

Best regards,

Lucas

2 replies

A
  • Anonymous
  • Answer
  • February 15, 2023

Hi François,

 

sounds like a problem you could solve with a PU_COUNT statement. You can use this in a filter statement to only get codes occurring twice or more. I can recommend checking the documentation, provides some good examples.

 

Best regards,

Lucas

F
Level 4
Forum|alt.badge.img+6

Hello Lucas,

 

I really thank you, you have redirected me in the right direction : a PU_COUNT was my first idea but the two attributes are in the same table so I looked into other directions ...

 

However I just needed to use also the Domain_Table function (which doesn't appear in the "PQL Reference" of my Code Editor as I am not on the cloud version of the tool, but seems working)

So, I write the filter if it can help anybody :

FILTER PU_COUNT_DISTINCT (DOMAIN_TABLE ("Case_Table"."Code"),"Case_Table"."Building") >1

 

Have a good day and thanks again,

Best regards

François

Community Code of ConductAccessibility statement