topic Re: When i select a sheet,unselect a field. in QlikView

When i select a sheet,unselect a field.

asknyldz — Tue, 18 Nov 2014 09:25:07 GMT

Hi there,

I'm new on Qlikview.

So,

When i select to Region Analysis tab, i want to can't see "İSTANBUL" values. But when i select to other Tabs, i must see all values.

Thank you for support.

Re: When i select a sheet,unselect a field.

jpenuliar — Tue, 18 Nov 2014 09:33:38 GMT

It is still not clear to me, which All values you want to see when you switch to other tabs.

All values regarding IstanbuL? in general, any selections you have made to a sheet will still show in you current selection object.

Depending on which you want to achieve, you can customize user experience in terms of selected values if you look into Sheet Properties>> Triggers>> OnActivateSheet & OnLeaveSheet properties.

in here you can add Selection Actions to you sheet,

Re: When i select a sheet,unselect a field.

ashfaq_haseeb — Tue, 18 Nov 2014 09:38:39 GMT

Hi,

Can you share sample app?

I believe adding trigger to exclude single value must work to Exclude Istanbul.

for other sheet add trigger to clear all selection

Regards

ASHFAQ

Re: When i select a sheet,unselect a field.

asknyldz — Tue, 18 Nov 2014 09:42:29 GMT

Dear Jonathan,

Thanks for reply.

Please forgot the switch other tabs. I need only, when i select to "Region Analysis" tab, i want to can't see "Istanbul" values, i must to see only other values.

Istanbul must be not selectable.

I try to Triggers, but İstanbul is still selectable.

Thank you.

Re: When i select a sheet,unselect a field.

ashfaq_haseeb — Tue, 18 Nov 2014 09:46:27 GMT

Hi,

Add trigger on activate sheet.

Select trigger select in field. Field name Region and in search string type this

=not Region like 'iSTANBUL'

Let me know if that worked.

Regards

ASHFAQ

Re: When i select a sheet,unselect a field.

arsal_90 — Tue, 18 Nov 2014 09:47:30 GMT

Use Trigger on Region Analysis tab. right click on sheet and go to properties and select trigger tab and add a action on Region field

Re: When i select a sheet,unselect a field.

jpenuliar — Tue, 18 Nov 2014 09:54:36 GMT

If you are using list box to make selection of Istanbul, you can do away with "Select Excluded" property.

But if you click on the Map, you have to have find another way to exclude, perhaps OnChange Trigger on your target field.

Re: When i select a sheet,unselect a field.

jpenuliar — Tue, 18 Nov 2014 09:58:31 GMT

not OnChange but OnSelect Trigger.

you can access Document Property (Ctrl+Alt+D) >> Triggers>>Field Event Triggers

Re: Re: When i select a sheet,unselect a field.

ashfaq_haseeb — Tue, 18 Nov 2014 10:14:09 GMT

Hi,

have a look at attached application.

Regards

ASHFAQ

Re: When i select a sheet,unselect a field.

asknyldz — Tue, 18 Nov 2014 13:51:37 GMT

Dear all,

I solved by Sheet Select Trigger.

Thanks for everyone for helps.

Re: When i select a sheet,unselect a field.

ashfaq_haseeb — Tue, 18 Nov 2014 15:29:05 GMT

Hi did you check my reply.

I gave you working example

Regards

ASHFAQ