topic Re: Selection is specific to sheet object in QlikView

Selection is specific to sheet object

Sun, 16 Mar 2014 04:54:07 GMT

i have requirement like if i make selection on list box then particular sheet objects example 'mysheet' objects only will effect and remaining objects presented in different sheets should not get effected.

Regards

Boby

Re: Selection is specific to sheet object

its_anandrjs — Sun, 16 Mar 2014 05:50:34 GMT

Hi,

Use GetFieldSelections function for this like

type this code in chart properties those you want to hide layout -> in show option select conditional ->

then type this code like

eg:- if(GetFieldSelections(YourList box field)>1,1,0)

If you make any selection in the list box chart get activated otherwise it is hide in the sheet

Thanks & Regards

Re: Selection is specific to sheet object

nagaiank — Sun, 16 Mar 2014 05:53:35 GMT

You may clear the field by adding the action on 'OnLeaveSheet' in Sheet Properties --> Triggers tab

Re: Selection is specific to sheet object

jagan — Mon, 17 Mar 2014 02:22:24 GMT

Hi Mahesh,

I didn't get you, can you come up with a sample file so that it is easier to understand. I think if you give {<DimensionName=>} in Set Analysis expression it won't consider the selections, so in sheet mysheet chart expressions give this in all expressions otherwise in

Sheet Triggers -> On Activate Sheet

clear that field in other sheets and use it in mysheet charts.

Hope this is what you expects.

Regards,

Jagan.

Re: Selection is specific to sheet object

Mon, 17 Mar 2014 04:11:40 GMT

generally we do selections it will be effected all related charts in different sheets but here i dont want

i want to restrict to only one sheet.

regards

Re: Selection is specific to sheet object

qlikpahadi07 — Mon, 17 Mar 2014 04:51:21 GMT

Dear Mahesh,

In your case you can activate a Trigger on every sheet when activated it will clear all the selections.

Steps:

right click Properties of selected sheet

go to Triggers

Click Add action button under "On action sheet"

Click add

select "clear all" option in "Selection"

you can use both "OnActivateSheet" or "OnLeaveSheet" option as per your requirement. but you need to do all these in every sheet.