Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Can you post some samples of your organization codes?
-Rob
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".
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
Thanks, I'll try it!