activ selection clear

[#1]

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

[#2]

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):

1. Select the sheet you want the macro to run on
2. Right click the sheet tab and select Sheet Properties
3. Select the Macro tab
4. If you have already added in the routine (see sample below) then select it in the OnActivateSheet drop down box
5. 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

[#3]

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

[#4]

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

[#5]

Hi Rod,

Thanks for your Help. Last week I was ill.

it was worked.

Thanks a gain

[#6]

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

[#7]

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