topic Re: Facing issues while doing Selections in QlikView

Facing issues while doing Selections

Mon, 14 Nov 2011 14:37:21 GMT

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

Sales Org
Market
Brand

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

I selected sales Org (RNA)
I selected Market (Asthma)
I selected Brand (Advair)
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).
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.

Facing issues while doing Selections

tabletuner — Mon, 14 Nov 2011 15:07:10 GMT

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

Facing issues while doing Selections

Tue, 15 Nov 2011 08:22:03 GMT

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

Re: Facing issues while doing Selections

Tue, 15 Nov 2011 08:22:51 GMT

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

Facing issues while doing Selections

SunilChauhan — Tue, 15 Nov 2011 08:30:22 GMT

hold control and then select multiple item

Facing issues while doing Selections

pat_agen — Tue, 15 Nov 2011 09:16:55 GMT

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

Facing issues while doing Selections

Tue, 15 Nov 2011 11:18:47 GMT

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

Re: Facing issues while doing Selections

Tue, 15 Nov 2011 11:20:59 GMT

Hi,

Thanks for the response.

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

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

Re: Facing issues while doing Selections

michael_anthony — Wed, 16 Nov 2011 00:17:06 GMT

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.

Re: Facing issues while doing Selections

michael_anthony — Wed, 16 Nov 2011 00:20:11 GMT

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.