topic activ selection clear in QlikView

activ selection clear

Tue, 30 Jun 2009 19:52:33 GMT

Hi,

i have 2 active selection for filter in two sheets in Qlikview and there have difference quelle.

How can I clean one of them, when I filter in another?

see attached Qlickview

Thanks

activ selection clear

Thu, 02 Jul 2009 13:09:08 GMT

Hi shideh,

You could add in a macro that is activated each time you select the second sheet. The macro would clear all the selections. To attach the macro to the sheet do the following (using version 8.5 SR5):

Select the sheet you want the macro to run on
Right click the sheet tab and select Sheet Properties
Select the Macro tab
If you have already added in the routine (see sample below) then select it in the OnActivateSheet drop down box
Click OK

For reference here is some code to clear all selections (even locked values).


Sub ClearAll
ActiveDocument.UnlockAll
ActiveDocument.ClearAll false
End Sub

I hope this is of some help.

Rod

activ selection clear

Thu, 02 Jul 2009 14:31:10 GMT

Hi Rod,

Thanks for your Help, but i want to clear not all. In my example I want to clear in sheet Entwicklung the field:

BP_Partner_Master-1.Bp_Account_Group_

When I exit from Analyse Order, because this Field is just in Analyse Order und not in Entwicklung. The Active Selection in sheet Entwicklung with the Filter:

Billing_Line.Billing_Line.Method_Of_Placement_ID_Description and Calendar should be not clear.

see attached QlikView.

Thanks

activ selection clear

Mon, 06 Jul 2009 06:11:50 GMT

Hi Sideh,

Use a sub routine (code below) and attach it to the Order Analyse sheet as per the following steps:

Right click on Order Analyse
Select Sheet Properties
Select the Macro tab
In the field OnLeaveSheet select the macro you created using the code below
Click the OK button


Sub ClearMyField
 ActiveDocument.Fields("BP_Partner_Master-1.BP_Account_Group_").Clear
End Sub

I hope this is of some help.

Rod

activ selection clear

Mon, 13 Jul 2009 15:20:22 GMT

Hi Rod,

Thanks for your Help. Last week I was ill.

it was worked.

Thanks a gain

activ selection clear

Mon, 13 Jul 2009 19:26:27 GMT

Hi Rod,

it is possible this Marko:

Sub ActiveMyField

ActiveDocument.Fields("BP_Partner_Master-1.BP_Account_Group_").Active

End Sub

i Will Active this Field by Marko. There is not work.

Thanks

activ selection clear

Wed, 15 Jul 2009 07:22:05 GMT

Hi Sideh,

If you are trying to create a Macro that preselects a field value then try something like this:


Sub ActiveMyField
ActiveDocument.Fields("BP_Partner_Master-1.BP_Account_Group_").Select "Corporate"
End Sub

I hope this is of some help.

Rod