Creating a "Group_1" Filter for Company Categories in Qlik Sense

[Niko910]

Hello Qlik Community,

I have a list of company names in my filter section in Qlik Sense, and I would like to add a Group_1 selection to categorize companies into groups (A, B, and C). Additionally, I want this Group_1 filter to appear in the same filter pane where I select the companies. For example:

• Group A: CompanyA, CompanyB
• Group B: CompanyC, CompanyD
• Group C: Other companies

How can I create this Group_1 filter in Qlik Sense, so that I can filter data by these groups while also using the same filter for selecting companies?

I’ve tried loading data into Qlik Sense, but I’m not sure how to categorize companies into these groups and add the Group_1 filter in the same selection pane as the company filter.

Any help would be greatly appreciated!

Thank you!

[martinpohl]

Hi,

to group your datas use:

load

*,

if(match(Company,'CompanyA','CompanyB'),'Group1',

if(match/Company,'CompanyC#;'CompanyD'),'Group2',

'Group3')) as CompanyGroup1

resident Your_table;

drop table Your_table;

You can't use a hierarchy filter but you can create an master dimension using drill down.

First level is ComapnyGroup1, second is company.

When selecting Group1, you only will get Company a or B

Regards.