topic How to make a selection based on another selection in QlikView

How to make a selection based on another selection (dynamically)

Tue, 02 Mar 2010 10:42:31 GMT

Hi guys,

I have the following problem: I have two listboxes: Code and Cost Center and I want when I make selection in Cost Center a several codes to be selected in Code list box.

I decided to make a macro:

sub SelectFirstLevelCodes

set CodeField = ActiveDocument.Fields("AccountCode")
set CostCenterFirstLevelField = ActiveDocument.Fields("CostCentersFirstLevel").getSelectedValues
for i=0 to CostCenterFirstLevelField.Count - 1

if CostCenterFirstLevelField.Item(i).Text="FirstCC" then
CodeField.Select "1*"
end if

if CostCenterFirstLevelField.Item(i).Text="SecondCC" then
CodeField.Select "2*"
end if

if CostCenterFirstLevelField.Item(i).Text="ThirdCC" then
CodeField.Select "3*"
end if
next
end sub

and it is working, except that I can select only one Cost Center. If I select two, Codes are selected only for the last selected CostCenter, not for both. How can I avoid this problem?

How to make a selection based on another selection

Tue, 02 Mar 2010 14:49:41 GMT

Hi there,

can you please take a look at this post and let me know if this what you try to achieve?

http://community.qlik.com/forums/t/25932.aspx

Thanks.

Lukas

How to make a selection based on another selection

blaise — Tue, 02 Mar 2010 16:04:10 GMT

May I ask why you dont join an inline table to your data tables instead.


CostCenterLevel:
LOAD * INLINE [
CostCenterFirstLevel,CodeField
FirstCC,1
SecondCC,2
ThirdCC,3
];

Otherwise (using your code) try changing the .Select to .ToggleSelect. Make sure to do a Field.Clear first, above the loop.

How to make a selection based on another selection

Tue, 02 Mar 2010 16:42:56 GMT

Hi there,

Luckas, I don't want to use a button with an action for selection. The idea is when I choose lets say FirstCC from a listbox in another listbox dynamically to be choosen let's say 100 values starting with 1 (100, 101, 102, etc.) I think that answers blase question, too. (May be blase didn't see the * after the digits)

I found a solution and it was to use "ToggleSelect", instead of "Select" and also had to add "CodeField.clear" before the loop so that it deselects the codes when I deselect the Cost Center.

How to make a selection based on another selection

blaise — Wed, 03 Mar 2010 23:45:43 GMT

Sorry for not seeing the wildcards. If you do a left(AccountCode,1) as key_AccountCode you can use my suggestion. Worth i try if the data is rather small or you do other "non qvd optimized" conversions.