How to prevent current selection to next sheets

[dunnalahk123]

Hi,

I have One QVW Report where i have 5 sheets with different views.

but if i select any filter in any first 4 Sheets it should apply to first four sheets only but not to fifth sheet.

how can i do it , can some one help me here.

Best Regards,

HK

[Anonymous]

use alternate states...

[dunnalahk123]

Hi Robin,

Thank you For your Quick Response.

Can just Explain how to use it as i did't used till now.

Best Regards,

Hk

[micheledenardi]

Alternate States ‒ QlikView

So you have to create 1 Alternate State(Document properties-> General -> Alternate State) for the fifth sheet and assign it to all objects of your fifth sheet.

[Anonymous]

Hi

Go to Settings>Sheet Properties>Triggers>Sheet Event Triggers>Add Action>Add>Selection>Under Action - Clear All> Ok>Ok>Ok

Now if you make selection on First sheet it will applies till 4th sheet. Once you come to 5th tab it will clear that selection.

Hope it helps!!

[Anonymous · Accepted solution]

For sheet 1 to 4 change nothing.

For sheet 5 add an alternate state

and then on sheet 5 set in the sheet propertys your new alternate state and make sure that all charts, listboxes etc inherit the state from the sheet...

[Anonymous]

but then it is cleared and your selection for sheet 1 to 4 is lost...

[Anonymous]

I agree ...

but be careful when using alternate states there's a difference between:

sum {< A= >} B)

and

sum {$< A= >} B)

[Anonymous]

Yes, then we have to go for Alternate State