This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
in a list box same values should be grouped. Can a tree structure be realized with a formula?
AD-K (A) AD-K (B) AD-K (C) AD-K (D)
AD-H (S) AD-H (T)
May be this
=If(Len(Trim(Site)) > 0 and Match(Site, 'AD', 'AS') = 0, SubField(Site, ' ', 1) & '/' & Site)
View solution in original post
Something like this?
LOAD * INLINE [
SubField(Site, ' ', 1) & '/' & Site as SiteTree
SubField(Site, ' ', 1) as SiteTree
Yes, but it is possible to create this view with a formula in listbox?
May be using this
=If(Len(Trim(Site)) > 0, SubField(Site, ' ', 1) & '/' & Site)
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?
SubField(Site, '-', 1)
What exactly are you wish to see in the list box?
Listbox should be filtered by: AD-K and AD-H
So you don't want to see AD and AS in site listbox?