Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
stefan_fischer
Contributor II
Contributor II

Group Site in ListBox

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

12 Replies
stefan_fischer
Contributor II
Contributor II
Author

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

sunny_talwar

May be this

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

View solution in original post

stefan_fischer
Contributor II
Contributor II
Author

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))