Facing issues while doing Selections

[#1]

I have a scenario in which I have few Selections as below:

1. Sales Org
2. Market
3. Brand

So, I am making selections, and while doing that I am following below steps:

1. I selected sales Org (RNA)
2. I selected Market (Asthma)
3. I selected Brand (Advair)
4. Then I selected another Market (Allergy)which is related to the Sales Org (RNA) selected in step 1 but not related to the Brand selected in Step 3 (Advair).
5. Now, selections in both Sales Org and Brand are actually clearing off

Issue: Selection should not go from Sales Org as it is related to the selection being done in Market.

For your reference, data is attached in the Excel.

[tabletuner]

Hi,

To me it seems like normal behaviour that when you cllick on another market, the current selection will be cleared.

It might be a solution for you to use control+click on the market value that you want to add. This way your current selection will not be lost. Deselect the selection in brand in your next step.

GL,

Tjeerd Wieberdink

[#3]

Hey,

Thanks for answering....

Yes actually its a default behaviour of QV.

But What I explained is the requirment of my Client.So even if its a default one, but needs to be

done....

Hoping for other useful ideas..!!!

Regards,

Neelam

[#4]

Hey,

Thanks for answering....

Yes actually its a default behaviour of QV.

But What I explained is the requirment of my Client.So even if its a default one, but needs to be

done....

Hoping for other useful ideas..!!!

Regards,

Neelam

[SunilChauhan]

hold control and then select multiple item

[pat_agen]

hi Neelam,

to vercome default qv behaviour with selections you can "lock" selections. This can be done in a fairly transparent way for users by using Triggers and Actions (as from v9) (tab document properties->triggers).

If your query path is going to be Sales-org and then investigating under this you could imagine the following.

On the Sales Org you place a Trigger on OnSelect. This trigger has a Lock Field action which locks the [Sales Org] field. You will now get the behaviour your client wants.

To change Sales Org the user would now have to unlock the field - to make this easier add the lock/unlock icon to your list box (see tab listbox properties->caption).

hope this helps

[#7]

Hi,

Thanks for the response.

In my case, my client actually dont even want to deselect the Brand (By deselecting brand , and then selecting some other Market which is related to already selected Sales Org), which would make this issue resolved.

Locking/Unlocking again and again would be messy for her.

I dont know... I am on the verge of giving up now..

[#8]

Hi,

Thanks for the response.

In my case, my client actually dont even want to deselect the Brand (By deselecting brand , and then selecting some other Market which is related to already selected Sales Org), which would make this issue resolved.

Locking/Unlocking again and again would be irritating for her.

I dont know... I am on the verge of giving up now..

[michael_anthony]

An extension to Pat.Agen's solution which may work if Sales Org is the field which you want to prevent being unselected.

Use the trigger to automatically set the Lock status on the Sales Org field when it changes.

On the list box / multi-box where user would select Sales Org, there is a setting called "Override Locked Field".  If you set this one, the user can leave the Sales Org as locked, but in the List / Multi-box still be able to change the selection.

That way, when user chooses a different Brand or Market, it won't allow that selection if it removes the Sales Org selection.  But when the user wants to look at a different Sales Org, they can force the selection.

[michael_anthony]

An extension to Pat.Agen's solution which may work if Sales Org is the field which you want to prevent being unselected.

Use the trigger to automatically set the Lock status on the Sales Org field when it changes.

On the list box / multi-box where user would select Sales Org, there is a setting called "Override Locked Field".  If you set this one, the user can leave the Sales Org as locked, but in the List / Multi-box still be able to change the selection.

That way, when user chooses a different Brand or Market, it won't allow that selection if it removes the Sales Org selection.  But when the user wants to look at a different Sales Org, they can force the selection.