topic Re: Decompose filter column in Reporting Service & Alerting

Decompose filter column

Nika3 — Thu, 14 Sep 2023 11:40:35 GMT

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!

Re: Decompose filter column

rwunderlich — Thu, 14 Sep 2023 18:34:14 GMT

Can you post some samples of your organization codes?

-Rob

Re: Decompose filter column

Nika3 — Fri, 15 Sep 2023 17:47:45 GMT

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".

Re: Decompose filter column

rwunderlich — Fri, 15 Sep 2023 19:04:53 GMT

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

Re: Decompose filter column

Nika3 — Mon, 18 Sep 2023 06:36:03 GMT

Thanks, I'll try it!