Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 II
Champion II

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 II
Champion II

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 II
Champion II

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 II
Champion II

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 II
Champion II

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