topic Re: Group Site in ListBox in QlikView

Group Site in ListBox

Anonymous — Wed, 07 Feb 2018 13:32:03 GMT

Hello,

in a list box same values should be grouped. Can a tree structure be realized with a formula?

AD-K

AD-K (A)
AD-K (B)
AD-K (C)
AD-K (D)

AD-H

AD-H (S)
AD-H (T)

Regards

Stefan

Re: Group Site in ListBox

sunny_talwar — Wed, 07 Feb 2018 13:40:38 GMT

Something like this?

Re: Group Site in ListBox

sunny_talwar — Wed, 07 Feb 2018 13:43:56 GMT

Or this

SiteView:

LOAD * INLINE [

Site

AD-K (A)

AD-K (B)

AD-K (C)

AD-K (D)

AD-H (S)

AD-H (T)

];

SiteTree:

LOAD Site,

SubField(Site, ' ', 1) & '/' & Site as SiteTree

Resident SiteView;

Concatenate(SiteTree)

LOAD Site,

SubField(Site, ' ', 1) as SiteTree

Resident SiteView;

Re: Group Site in ListBox

Anonymous — Wed, 07 Feb 2018 13:50:08 GMT

Yes, but it is possible to create this view with a formula in listbox?

Re: Group Site in ListBox

sunny_talwar — Wed, 07 Feb 2018 13:52:42 GMT

May be using this

=If(Len(Trim(Site)) > 0, SubField(Site, ' ', 1) & '/' & Site)

Re: Group Site in ListBox

Anonymous — Wed, 07 Feb 2018 14:13:47 GMT

Great. If i have more values like AS and AD in listbox, and only AD-K and AD-H will show in listbox. How is this formula?

Re: Group Site in ListBox

sunny_talwar — Wed, 07 Feb 2018 14:15:17 GMT

May be this

SubField(Site, '-', 1)

Re: Group Site in ListBox

sunny_talwar — Wed, 07 Feb 2018 14:16:15 GMT

What exactly are you wish to see in the list box?

Re: Group Site in ListBox

Anonymous — Wed, 07 Feb 2018 14:17:47 GMT

Listbox should be filtered by: AD-K and AD-H

Re: Group Site in ListBox

sunny_talwar — Wed, 07 Feb 2018 14:25:32 GMT

So you don't want to see AD and AS in site listbox?

Re: Group Site in ListBox

Anonymous — Wed, 07 Feb 2018 16:31:44 GMT

Yes, i don't want to see AD and AS.

Re: Group Site in ListBox

sunny_talwar — Thu, 08 Feb 2018 12:17:20 GMT

May be this

=If(Len(Trim(Site)) > 0 and Match(Site, 'AD', 'AS') = 0, SubField(Site, ' ', 1) & '/' & Site)

Re: Group Site in ListBox

Anonymous — Thu, 08 Feb 2018 12:58:52 GMT

Now it's working fine. Many Thanks for you help.

Also working:

=If(Left(Site,3)='AD-', SubField(Site, ' ', 1) & '/' & Aggr(Only({<site = {'AD-K*', 'AD-H*'}>} Site), Site))