Clear state on activate sheet

[helen_pip]

Dear Qlikview user

I have a list box which has 3 values

Division

Care Group

Total

I have clicked on the "Total" option and then under the tool bar--> Selections-->Set Clear State

So if a user selects Division and then unselects Division, Total remains selected

However the "Set Clear State" gets cleared when I move away from the sheet.  I was wondering if someone could kindly help me put an action on triggers which will force the "Set Clear State" when opening the page

I am currently playing around with this macro an trying to get it to suit my needs:

sub resetClearState

ActiveDocument.Fields("_dimension_OP").Unlock

ActiveDocument.Fields("_dimension_OP").Select "Total"

ActiveDocument.Fields("_dimension_OP").SelectExcluded

ActiveDocument.SetClearState

end sub

Kind Regards

Helen

[ogautier62]

Hi,

in sheet actions : when sheet opened

add an action : select in field "dim" value 'total'

is this you want ?

and what about your prior post ?

regards

[neha_shirsath]

You need to set trigger on your .qvw file.

If you are using macro then make sure that if it is working on Access Point.

Regards,

Neha