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
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
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
