topic Re: sheet selection in QlikView

sheet selection

mario-sarkis — Thu, 26 Mar 2015 12:47:52 GMT

Dear All,

well i am working on a dashboard i have in several sheets Ex:

Sheet 1 , Sheet2 , Sheet3

when i select on ID in sheet1 this will filter also sheet 2 and sheet3 by this ID (this is not a problem to me )

my problem is when i select an ID in the sheet 1 i want to clear this selection when moving to sheet 2 or 3.

Help.

Thank you,

MK_QSL — Thu, 26 Mar 2015 12:59:03 GMT

Settings

Sheet Properties

Triggers

OnLeaveSheet >> Add Action

Add

Selection

Clear All

jsanchezh — Thu, 26 Mar 2015 12:59:11 GMT

Hello,

You can try this:

>> Right click with your mouse on "Sheet1"

>> Sheet Properties

>> The last tab after security (which should be something like trigger or shooter, i have Qlikview on my language)

>> Then "add actions" when leaving the sheet

>> Add >> Selection >> Delete Field and then you can select your field (ID)

I hope it helps you

Greetings!