topic Re: List Box Properties: Grouping? in QlikView

List Box Properties: Grouping?

knightwriter — Wed, 20 May 2015 14:56:16 GMT

Hi All,

If I have a list of activities in a List box, is it possible to add an expression or definition to group some activities together?

For example my current list box is:

Event - rock climbing

Event - hill climbing

Event - swimming

Training - presentation

Training - one to one

Outcome I want is:

Event

Training

Many thanks.

Re: List Box Properties: Grouping?

JonnyPoole — Wed, 20 May 2015 15:02:13 GMT

You can alter the list box to show the results of an expression rather than a field with this:

Then bucket the values with an expression . Lots of possibilities. Here is one with wildcard matching and i threw in an 'other' category if you get unexpected values.

if( wildmatch([FieldName],'Event*'),'Event', if( wildmatch([FieldName],'Training*','Training','Other'))

Re: List Box Properties: Grouping?

b_garside — Wed, 20 May 2015 15:03:39 GMT

Most likely you will need to add a delimiter to create the hierarchy or to create a Group type column and use that instead.

The list box has a option called "Show as TreeView" its default delimiter is '/'

Re: List Box Properties: Grouping?

awhitfield — Wed, 20 May 2015 15:05:19 GMT

Not sure if this s was you want, first list box has expression rather than a field

=pick(wildmatch(Item, 'Event*','Training*'),

'Events', 'Training')

Re: List Box Properties: Grouping?

knightwriter — Wed, 20 May 2015 15:14:57 GMT

Great response to use an expression, thank you.

Can I use =([Activity.Type]='Event - rock climbing', 'Event',) etc?

It doesnt seem to be working?

Re: List Box Properties: Grouping?

Wed, 20 May 2015 15:16:00 GMT

Hello Stephen,

You can also create a map to a new field with these categories "grouped" if you expect these categories to grow over time, this would make it easier to maintain, not sure performance wise if would be a better solution. Please see the attached sample.

Regards,

Enrique

Re: List Box Properties: Grouping?

nagaiank — Wed, 20 May 2015 15:17:39 GMT

You may use the expression

=Trim(SubField(Field,'-',1))

for the listbox to get the desired outcome.

Re: List Box Properties: Grouping?

b_garside — Wed, 20 May 2015 15:22:44 GMT

If you looking for an expression type solution vs script as suggested try what NagaianK posted in his reply.

Re: List Box Properties: Grouping?

JonnyPoole — Wed, 20 May 2015 15:27:02 GMT

you can but you need to use nested IF()

if( [Activity.Type]='Event - rock climbing', 'Event', if ( <condition> , true result value, false result value) )