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: 
deepakqlikview_123
Specialist
Specialist

Clear all selection in qlikview

Hi All,

I am using clear all.on different different sheet.

On one of clear all i have applied alternate state while on other did not applied but when i am using clear all  (inherited state), my other default selection on clear having alternate state all is also disappearing.

can you please suggest on this

12 Replies
MK_QSL
MVP
MVP

Provide sample file...

You can select Alternate State in Action tab also...!!

deepakqlikview_123
Specialist
Specialist
Author

Hi Manish,

PFA.

I have sheet1 and she applied condition as region = all in clear button of sheet 2 so that whenever clear on sheet 2 happens it will directly shows region all but when i can apply clear on sheet 1 in my sheet 2 default selection also disappears moreover when ever i can choose region on sheet 2 region selection appears in current selection box of sheer 1 although there is no region list box.

thanks

deepakqlikview_123
Specialist
Specialist
Author

hi all,

Can you please suggest on this.

Thanks

settu_periasamy
Master III
Master III

Hi deepak,

Can you tell the steps what would happen if we click the Sheet 1 ClearAll Button and if We click the Sheet 2 Clear All Button?

Not applicable

Hi,

I think it will help u to complete the task

r.click on sheet go to sheet properties

Go to triggers -> there u can see onleave sheet -> click on edit actions -> click on ADD -> under selection -> u can see the clear all -> ok ->ok -> apply -> ok

Hope it will help u.

Thank you,

Balaji.k

deepakqlikview_123
Specialist
Specialist
Author

I am using clear all.on different different sheet.

On second sheet clear all i have applied alternate state while for first sheet did not applied but when i am using clear all  (inherited state) for first sheet, my other default selection on clear having alternate state(second sheet) all is also disappearing.on second sheet Region='All' should be default.er clearing moreover region selection should not appear on first sheet's current selection box

deepakqlikview_123
Specialist
Specialist
Author

its not working

settu_periasamy
Master III
Master III

Hi deepak,

if i understood correctly, Try this

In the first Sheet -> Clear All Button -> Give the Default State.

deepak.JPG

deepakqlikview_123
Specialist
Specialist
Author

hi settu,

it is already in default state.

thanks