topic group for a list object value in QlikView

group for a list object value

qlik_venu — Fri, 10 Sep 2010 12:07:37 GMT

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

group for a list object value

qlik_venu — Fri, 10 Sep 2010 12:08:35 GMT

file

group for a list object value

johnw — Fri, 10 Sep 2010 21:02:39 GMT

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)

group for a list object value

qlik_venu — Mon, 13 Sep 2010 14:27:17 GMT

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.

group for a list object value

johnw — Mon, 13 Sep 2010 17:58:52 GMT

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.