Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Nika3
Contributor II
Contributor II

Decompose filter column

Hello together !
I have a question:
Is it possible to decompose a filter qusi in qlik sense?
For example I have organization code that consists of 3 levels, and I need to separate these 3 levels and have extra level 1, level 2, and level 3. Maybe someone could help me.
Thanks in advance!

Labels (1)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You could create three new fields if that would meet your requirement.

SubField(OrgCode, ' '. 1) as Level1, 
SubField(OrgCode, ' '. 2) as Level2, 
SubField(OrgCode, ' '. 3) as Level3

-Rob

 

View solution in original post

4 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Can you post some samples of your organization codes?

-Rob

Nika3
Contributor II
Contributor II
Author

It's a set of letters: for example, ABS ZK RON, it goes from the largest to the smallest (i.e., first the global name, then to narrower areas) In a hierarchical order of compounds. And I need it to filter each one individually, each level, or so-called "step".

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

You could create three new fields if that would meet your requirement.

SubField(OrgCode, ' '. 1) as Level1, 
SubField(OrgCode, ' '. 2) as Level2, 
SubField(OrgCode, ' '. 3) as Level3

-Rob

 

Nika3
Contributor II
Contributor II
Author

Thanks, I'll try it!