Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Selection in qlikview

Hi All,

I have requirement like below,

For one of sheet I need to show selection for only Month='Dec', Year='2016', whenevr I am navigating to other sheet I need to clear the selection and show all data as it is.

Can you please suggest how to proceed.

Thanks

8 Replies
adamdavi3s
Master
Master

Just use a trigger on the sheet to select / clear the values as necessary

sunny_talwar

or you can also use Alternate state for the particular tab (not sure how exactly you plan to use it, but the closest solution to you description seems to be adamdavi3s‌ idea of using sheet level triggers)

sagarkharpude
Creator III
Creator III

Go to sheet properties -> Triggers -> Actions

Then select the field and value

deepakqlikview_123
Specialist
Specialist
Author

Thanks but can you please suggest how should i clear the selection for remaining sheets so that default view can be displayed.

Thanks

sunny_talwar

Use on leave trigger on this same sheet to clear selections in Year and Month field or clear all fields (based on your requirement)

Capture.PNG

adamdavi3s
Master
Master

As per my original answer which this one just repeats, just use a clear field function on a leave sheet trigger

deepakqlikview_123
Specialist
Specialist
Author

Hi All,

When I am clearing selection in access point default selection is not selected on a sheet where I have applied the trigger.

Thanks

annafuksa1
Creator III
Creator III

you need to set triggers 'on ActivateSheet'- so when you open the tab its clear all selection and next apply the year and month filters (order is very important)

and you can on leave for example clear all if you need but