topic Re: How to make same filter single select on one sheet and multi select on another sheet in QlikView

How to make same filter single select on one sheet and multi select on another sheet

Fri, 24 May 2013 05:38:32 GMT

Hi everyone ,

I have a filter "Year" on two sheets , I want to make it multiselect on one sheet where as single select on other sheets , I have written these macros which I am running over sheet activation , "makeYearSingle" where I want to make year single select and "makeYearMultipleSelect" where I want to make it multiselect , but they are not working , can anyone address the problem ???

Sub makeYearSingle

set sheet=ActiveDocument.ActiveSheet

set objProperties=sheet.GetSheetObject("LB19").GetProperties

objProperties.AlwaysOneSelectedValue=true

End Sub

Sub makeYearMultipleSelect

set sheet=ActiveDocument.ActiveSheet

set objProperties=sheet.GetSheetObject("LB11").GetProperties

objProperties.AlwaysOneSelectedValue=false

End Sub

Re: How to make same filter single select on one sheet and multi select on another sheet

Gysbert_Wassenaar — Fri, 24 May 2013 06:45:42 GMT

If you're using QV11 you can create alternate states and assign the different alternate states to the different sheets. You can then apply selections to the separate alternate states so in one sheet (alternate state X) you select one year and in the other sheet (alternate state Y) you select multiple years. You can use Select in Field actions assigned to a button (or text box) to do that. Macro's are not needed. If you still want to use macro's you'll have to figure that out yourself. I have no idea if alternate states can be used in macro's.

Re: How to make same filter single select on one sheet and multi select on another sheet

Fri, 24 May 2013 06:48:40 GMT

Thanks Gysbert...