Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make selections on a sheet not efective on another sheet

Hi,

Anybody knows how to make a selections on a sheet not effective on another sheet.

like I have to Sheets on my report.

both of them have year, month and other selections..

I was wondering how can I make that..if I make selection on a first sheet the second one doesn't get effected.

Thxs

11 Replies
SunilChauhan
Champion
Champion

if you are using  qv 11 the use comperative analysis.that is good option available in qv 11.

Sunil Chauhan
Not applicable
Author

I am using V 10

I have looked at the one on V11..I wish I have it

SunilChauhan
Champion
Champion

or you can exclude the selection using set analysis.

ex:

suppose you want to exclude selection of Year and Month

then in chart you can use

sum({<Year=,Month=>}Sales)

hope this helps

Sunil Chauhan
Not applicable
Author

Thxs but not what I am looking for.

I need to do something simillar to comperative analysis in V11..

Regards,

SunilChauhan
Champion
Champion

or else you can see the  link below

on next sheet activate it will clear all selection

http://community.qlik.com/message/151416#151416

Sunil Chauhan
Not applicable
Author

This seems to be what I need but there is no explanation on how to do it.

May you please help me on how to do that.

Thxs so much

SunilChauhan
Champion
Champion

right click on sheet you do not want selection

then go to properties->triggers-> on activate-> add ->selection-> clear all

hope this helps

Sunil Chauhan
SunilChauhan
Champion
Champion

see the attched file

hope this helps

Sunil Chauhan
Not applicable
Author

This is helpfull but I am still having a little thing..

when I set that on sheet A

then I go to Sheet b and make several selections..

I go back to sheet A and it works fine ..

then If I go to sheet B again it clears everything there as well. while I dont want it to clear Sheet B

Thxs