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

1 Solution

Accepted Solutions
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

12 Replies
sunny_talwar

Something like this?

Capture.PNG

sunny_talwar

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;

stefan_fischer
Contributor II
Contributor II
Author

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

sunny_talwar

May be using this

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

stefan_fischer
Contributor II
Contributor II
Author

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?

sunny_talwar

May be this

SubField(Site, '-', 1)

sunny_talwar

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

stefan_fischer
Contributor II
Contributor II
Author

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

sunny_talwar

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