Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!