topic Re: Issue with trigger and clear selection in QlikView

Issue with trigger and clear selection

Mon, 20 Oct 2014 11:02:20 GMT

Hi,

I am facing following issue with trigger and Clear selection.

Sample app attached :

Steps:

Clicking on any value in list box ClickToTrigger will activate sheet1. To achieve this we have created Field Event Trigger OnSelect for ClickToTrigger.
Navigate to sheet2 from sheet1.
Select Value on sheet2.
Clear value on sheet2.
It will automatically navigate back to Sheet1.

Is this QlikView Bug? Is there any workaround for this?

Re: Issue with trigger and clear selection

ashfaq_haseeb — Mon, 20 Oct 2014 11:13:25 GMT

Hi,

This is working as expected

What are you trying to achieve here?

Regards

ASHFAQ

Re: Issue with trigger and clear selection

Mon, 20 Oct 2014 11:18:34 GMT

Ashfaq,

The issue here is if a user is on sheet 2 and any filter is selected and than cleared , app is navigated to Sheet1, which is not desired result, user should remain on sheet2.

Regards,

Manjiri

Re: Issue with trigger and clear selection

ashfaq_haseeb — Mon, 20 Oct 2014 11:28:10 GMT

Then you need to think of some other logic to navigate instead of field event trigger.

For any selection in field Click to trigger you need to navigate to sheet1 or what is the logic can you explain.

Regards

ASHFAQ

Re: Re: Issue with trigger and clear selection

tresB — Mon, 20 Oct 2014 11:33:28 GMT

You may try:

=If(GetSelectedCount(ClickToTrigger), 'SH02')

as sheet activation expression.

PFA

Re: Issue with trigger and clear selection

Mon, 20 Oct 2014 11:44:46 GMT

Thanks tresesco but it is still not working. In the sample app attched by you if you go to sheet 2 select any value in Value list box and then clear it, it is navigating to sheet 1. Expected behaviour is it should stay on sheet 2.

Re: Issue with trigger and clear selection

tresB — Mon, 20 Oct 2014 11:49:30 GMT

If you goto sheet2 and select one value, it would goto sheet1. Come back to sheet2 when something is selected and clear it, it would ramains on sheet2. Isn't this what you want?

Re: Issue with trigger and clear selection

Mon, 20 Oct 2014 12:04:13 GMT

My Actual report flow is as follows :

1. Page 1 have all Department level information.

2. When user clicks on any Department it will navigate to nest sheet using trigger where we have Cost detail information for select department.

3. We have created custom tabs for Cost, Quality and utilization Detail information for selected department.

Issue :

1. User comes to Cost Detail page from homepage using trigger.

2. Navigate to Quality Page using custom tab.

3. Select some values on that page.

4. When user clears selection on that page report automatically navigates to Cost page (landing page of trigger).

In sync with the attached sample, if we navigate on sheet 2 from sheet one, do selection on sheet 2 and clear it it should remain on sheet 2, but right now it is navigating to sheet 1.

Thanks in advance for your quick response.

Regards,

Manjiri