Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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
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.
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?
yes I'm using the statement to create Region.
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;
This works perfect, thanks so much sunny.
Much Appreciated...!!!