topic Re: Clear state on activate sheet in QlikView

Clear state on activate sheet

helen_pip — Fri, 22 Jun 2018 10:39:43 GMT

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

Re: Clear state on activate sheet

ogautier62 — Fri, 22 Jun 2018 11:20:07 GMT

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

Re: Clear state on activate sheet

neha_shirsath — Fri, 22 Jun 2018 11:59:03 GMT

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