need help in selection in mutli box

[vikasshana]

Hi,

I've a below multi box in my Qlikview app and the name of the multi box is Region.

Region
A
B
C
D
E

Count of A is 10,B is 20, C is 10, D is 10, E is 10 so if I select all the region in multi box I get the count of 60.

Now my clients requirement is he wants a new line in the multi box called 'All', so when ever he selects 'All' in the drop down he has to see the count of all the regions in the multi box like below.

Region
All
A
B
C
D
E

So now when ever client click on 'All' he has to get the count of '60'.

Regards,

Vikas

[sunny_talwar]

May be do this in the script

LinkTable:

LOAD DISTINCT Region,

     Region as New_Region

FROM ....;

Concatenate (LinkTable)

LOAD DISTINCT Region,

     'All' as New_Region

FROM ...;

Now use New_Region for multibox use

[vikasshana]

thanks for that sunny but the Region column which I'm using is a pick function like below.

pick(wildmatch(NETBIOS_NAME,'A*','B*','C*','D*','E*'),'A','B','C','D','E') as Region.

Here NETBIOS_NAME is the field coming from my table.

[sunny_talwar]

But you need to do this after you have already created Region.... you are using the above statement to create Region in your fact table, right?

[vikasshana]

yes I'm using the statement to create Region.

[sunny_talwar · Accepted solution]

So, lets say this is your fact table

Fact:

LOAD ....

    pick(wildmatch(NETBIOS_NAME,'A*','B*','C*','D*','E*'),'A','B','C','D','E') as Region

FROM ....;

Now all you need to do is add this to your script

LinkTable:

LOAD DISTINCT Region,

    Region as New_Region

Resident Fact;

Concatenate (LinkTable)

LOAD DISTINCT Region,

    'All' as New_Region

Resident Fact;

[vikasshana]

This works perfect, thanks so much sunny.

Much Appreciated...!!!