group for a list object value

[qlik_venu]

Hi,

I need to create a group for 3 values in the list object. Is it possible to create a group of this sort.

I have attached a qlikview snapshot.

I need to create a PETS as a value in the List object, which should contain all the values of PETS A, PETS B and PETS C.

Is this possible in qlikview.

Thanks,

Venu

[qlik_venu]

file

[johnw]

Create a new list box. Set Field to <Expression>. Edit the expression and enter this:

=if(match(AU_TEAM,'PETS A','PETS B','PETS C'),AU_AGENT)

[qlik_venu]

hi John,

I want the group - say PETS ALL to be created in the TEAM list object itself,

The Team should contain PETS ALL, PETS A, PETS B, PETS C and other values. SO whenever PETS ALL is selected, it would selected all reated values of A,B and C in the Agent list.

Can you please check this. Thanks for your help.

[johnw]

Well, I can't test since I don't have your source data, but I'm guessing something like this:

CONCATENATE (AU_TEAM_D)
LOAD
'PETS ALL' as AU_TEAM
,AU_EMPLOYEE_NUMBER
,AU_SOURCE_NUMBER
,AU_USER_ACCOUNT_KEY
,AU_EXTENSION
RESIDENT AU_TEAM_D
WHERE match(AU_TEAM,'PETS A','PETS B','PETS C')
;

Though that might cause issues depending on how you handle the rest of the data in your application. This might or might not be better:

AU_TEAM_GROUPS:
LOAD
AU_TEAM as AU_TEAM_GROUP
,AU_TEAM
RESIDENT AU_TEAM_D
;
CONCATENATE (AU_TEAM_GROUPS)
LOAD * INLINE [
AU_TEAM_GROUP, AU_TEAM
PETS ALL, PETS A
PETS ALL, PETS B
PETS ALL, PETS C
];

Then use AU_TEAM_GROUP in your list box instead of AU_TEAM.