How to use a multiple-column-combination variables in the analysis

Question

Hello, I want to create a variable that defines Area_of_Business. it would be a combination of the Department and Type of the Business. It is not a problem to create the variable but rather to integrate it into the graphs and diagrams as I cant use "CEL_CASES"."AREA"=Variable (dont have a column called "AREA") or "CEL_CASES"."DEPARTMENT"=Variable or "CEL_CASES"."TYPE_OF_BUSINESS" =Variable in the quiry. Any ideas how to implement it?

Best,

Maria

greg.zajac · Answer

Hi @1460043253- this is definitely possible to implement in PQL.Create the Area_of_Business variable.Populate it using a button dropdown with the "load entries" option.In the PQL window that appears, write "CEL_CASES"."DEPARTMENT" || ' - ' || "CEL_CASES"."TYPE_OF_BUSINESS". This creates a list of distinct Department + Type combinations. Make sure to set your wrapping characters to single quotes.In all charts, graphs, and filters, you can now write conditions which check the variable as follows: "CEL_CASES"."DEPARTMENT" || ' - ' || "CEL_CASES"."TYPE_OF_BUSINESS" = <%=Area_of_Business %>Hope this helps!

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN