topic Re: Group items usign expression in ListBoxes in QlikView

Group items usign expression in ListBoxes

Anonymous — Wed, 26 Jun 2013 09:53:14 GMT

Hi,

I am having the problem shown in the example that I attach.

Basically, I have to give the user the possibility to select the activities (Activity1.A, Activity1.B, etc) that a given company (Company1) performs. Each single acitivity belongs to an activity group (Group1, Group2).

The solution that the client would like to have is Solution1 in the example: a single listbox where the values are already divided by group.
I used an expression to choose the elements that should go in certain listbox: =If(Group='Group1', Activity).

I am facing two problems now:

1. Compared to the standard Solution2 when I select an item linked to group 1 (e.g. Activity1.A from the listbox "Activity Group 1") then I am not allowed to select an element from "Activity Group 2" without losing the selection in "Activity Group 1". In Solution2 I can select items linked to different group.

2. In Solution1 I would like the underlying group selection to be completely transparent to the user. With that in mind I implemented Solution3 where the group column is now called %GroupHidden and HidePrefix is set to %. But, if a user selects an activity in one of the two listboxes in solutions 3 (e.g. Activity1.A in "Activity Group Hidden 1") and then clears the selection from the Current Selection Box the underlying group activity (%GroupHidden) is still selected and the activities in "Activity Group Hidden 2" are still greyed out.

Is there any neat and clear solutions to group values coming from the same table field in different listboxes?
PS: I know I could build n different Activity (ActivityGroup1, ActivityGroup2, etc.) tables and link them to a main "Company" table, but I am wondering if there is any other alternative way.

Thank you

Re: Group items usign expression in ListBoxes

Gysbert_Wassenaar — Wed, 26 Jun 2013 10:00:51 GMT

There's no easy way to automatically generate a listbox for each value from a field. You'd need a big ugly macro to do that.

Try the expression aggr(Activity,Activity) for the Activity listbox of solution two.

Re: Group items usign expression in ListBoxes

Anonymous — Wed, 26 Jun 2013 10:23:26 GMT

Thank you for taking the time to answer Gysbert, much appreciated.

The idea was actually to have the activity value aggregated by group, without losing the possibility to choose activities that belong to different groups.

I might have misunderstood your suggestion, but it doesn't seem to do the trick.

Re: Group items usign expression in ListBoxes

Gysbert_Wassenaar — Wed, 26 Jun 2013 10:24:39 GMT

Simply select another group first and then select the activity.

Or try Group&'/'&Activity as expression and enable the Show as Treeview option.

There's no simply and/or clean option to create listboxes for each value of a dimension.

Re: Group items usign expression in ListBoxes

Anonymous — Wed, 26 Jun 2013 11:20:49 GMT

Thank you Gysbert. I like the treeview suggestion, it is something worth considering.