Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Facing issues while doing Selections

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.

9 Replies
tabletuner
Creator III
Creator III

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

Not applicable
Author

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

Not applicable
Author

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
Champion
Champion

hold control and then select multiple item

Sunil Chauhan
pat_agen
Specialist
Specialist

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

Not applicable
Author

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..

Not applicable
Author

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
Creator II
Creator II

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
Creator II
Creator II

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.