topic Re: Create 2 Groups out of 1 FieldName (List Box) in QlikView

Create 2 Groups out of 1 FieldName (List Box)

aveeeeeee7en — Wed, 05 Mar 2014 05:51:18 GMT

Hi Experts

I have 1 Question??

Suppose there is 1 List Box Country which contains 4 values USA, England, Russia, China

I want to make 2 Groups - "Group1" & "Group2" from Country Field such that on "Group1" selection it can select All Field Values

and on "Group2" Selection it can Select only Russia & China excluding USA & England.

I want to make only one field which contains "Group1" & "Group2"

Regards

Aviral Nag

Re: Create 2 Groups out of 1 FieldName (List Box)

tresB — Wed, 05 Mar 2014 06:05:01 GMT

Since Group1 and Group2 are not mutually exclusive, you can't opt for calculated expression in the list box. you can try:

Option1: Create an inline field with two values, Group1 and Group1, and then use trigger to select values from your target field on 'on selection' event in this new field.

Option2: Again in the script, create a generic association between these fields.

Hope this gives you an idea.

Re: Create 2 Groups out of 1 FieldName (List Box)

Wed, 05 Mar 2014 06:34:16 GMT

through a bookmark?

Re: Create 2 Groups out of 1 FieldName (List Box)

sujeetsingh — Wed, 05 Mar 2014 06:44:20 GMT

See this sample it as per you need

Re: Create 2 Groups out of 1 FieldName (List Box)

sujeetsingh — Wed, 05 Mar 2014 06:45:32 GMT

Just select in the List box Group

Re: Create 2 Groups out of 1 FieldName (List Box)

aveeeeeee7en — Wed, 05 Mar 2014 19:34:44 GMT

Thank You Sujeet. It worked like a Charm.

Awesome Stuff.

Regards

Aviral Nag

Re: Create 2 Groups out of 1 FieldName (List Box)

aveeeeeee7en — Wed, 05 Mar 2014 19:35:47 GMT

Thank You Tresesco.

Loved your Suggestions. Very Useful.

Regards

Aviral Nag