topic Re: need help in selection in mutli box in QlikView

need help in selection in mutli box

vikasshana — Thu, 25 Jan 2018 12:15:02 GMT

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

Re: need help in selection in mutli box

sunny_talwar — Thu, 25 Jan 2018 12:21:54 GMT

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

Re: need help in selection in mutli box

vikasshana — Thu, 25 Jan 2018 12:28:38 GMT

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.

Re: need help in selection in mutli box

sunny_talwar — Thu, 25 Jan 2018 12:32:35 GMT

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?

Re: need help in selection in mutli box

vikasshana — Thu, 25 Jan 2018 12:33:46 GMT

yes I'm using the statement to create Region.

Re: need help in selection in mutli box

sunny_talwar — Thu, 25 Jan 2018 12:35:37 GMT

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;

Re: need help in selection in mutli box

vikasshana — Thu, 25 Jan 2018 12:39:35 GMT

This works perfect, thanks so much sunny.

Much Appreciated...!!!