topic Default selection for a sheet is not working Web view.....? in QlikView

Default selection for a sheet is not working Web view.....?

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Sheet Level default selection are not working in the Web view.

Ex:In Sheet Properties -> Triggers -> On Active Sheet -> Select in Field

The above procedure used to get implement the default selection to a sheet.

Can some one suggest me what is the issue.

Regards,

Venugopal G

Re: Default selection for a sheet is not working Web view.....?

Wed, 27 Apr 2016 04:32:31 GMT

Hi there,

It works fine for me, I tried the example that you do for Select In Field. Are you sure the name of the Field and the Search String is correct?

Re: Default selection for a sheet is not working Web view.....?

Wed, 27 Apr 2016 04:39:27 GMT

What is the default selection you are trying to make?

On Sheet Properties -- Triggers -- OnActivateSheet -- AddActions -- Selection -- Select in Field

Field as YEAR

Search String MAX(YEAR)

If this is written, then by default max year will be selected whenever you come to this page.

This will work in web view as well

Re: Default selection for a sheet is not working Web view.....?

clondono — Wed, 27 Apr 2016 04:44:50 GMT

Venugopal make sure your field and search string in the Actions property box are valid:

Re: Default selection for a sheet is not working Web view.....?

Wed, 27 Apr 2016 08:52:35 GMT

Hi Carlos,

Thanks for your Reply,

i had tried the above procedure and actions are also valid. what ever actions i applied those actions are working fine in Qlikview desktop level.But when we are checking in web-View those actions are not applying.

Screen shot for your refrenece.

Re: Default selection for a sheet is not working Web view.....?

awhitfield — Wed, 27 Apr 2016 15:00:56 GMT

Does it work when you are NOT using WEB VIEW?

Andy

Re: Default selection for a sheet is not working Web view.....?

Thu, 28 Apr 2016 04:57:29 GMT

Try using Toggle select and check

Re: Default selection for a sheet is not working Web view.....?

ramasaisaksoft — Thu, 28 Apr 2016 13:27:59 GMT

Hi Venu,

You will get this issue because of Association problem between fields.

you already have 3 different "Select in Field" Trigger actions .If you don't have any association between those fields you will not get any one field is gave this type of issue.

i.e 1st trigger action field is not having relation/Association with another field(2nd or 3rd Select in Field).

Re: Default selection for a sheet is not working Web view.....?

jerrysvensson — Thu, 28 Apr 2016 13:39:27 GMT

It doesn't work in WebView, see Reference manual. Works fine when using plugin.

Re: Default selection for a sheet is not working Web view.....?

Thu, 28 Apr 2016 13:51:18 GMT

Hi Freinds,

Thanks for all your reply,

Default selection are working in web-view when i am going via selecting sheet1 to sheet2 tab at the top.

But in my case i used button to navigate from sheet1 to sheet2. So when i am using the button action the default selection in the sheet2 are not working in Web-view.

Regards,

Venugopal G

Re: Default selection for a sheet is not working Web view.....?

awhitfield — Thu, 28 Apr 2016 15:47:17 GMT

try combining the actions on the button to perform both tasks.

Andy

Re: Default selection for a sheet is not working Web view.....?

SHARONIGOSWAMI — Thu, 10 Sep 2020 07:53:50 GMT

The reason it is not working is because the trigger is on the sheet and not on the button. So it works with the tabs, but not when you navigate using buttons.

Solution-

Right click on the button navigating to the sheet-->Properties-->Actions

This section would already have one action (Activate Sheet)

Add two more actions-

Selection--->Clear All (After Activate Sheet)

Selection--->Select in Field (After Clear All). Here, put the field name and condition the same as behind the sheet trigger.

Apply this to all the buttons redirecting to this page. Your button navigation will now work the same as your tab navigation with default selections even in Web view.