Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if you are using qv 11 the use comperative analysis.that is good option available in qv 11.
I am using V 10
I have looked at the one on V11..I wish I have it
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
Thxs but not what I am looking for.
I need to do something simillar to comperative analysis in V11..
Regards,
or else you can see the link below
on next sheet activate it will clear all selection
http://community.qlik.com/message/151416#151416
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
right click on sheet you do not want selection
then go to properties->triggers-> on activate-> add ->selection-> clear all
hope this helps
see the attched file
hope this helps
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