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: 
nikhilgarg
Specialist II
Specialist II

How to set trigger of select in field on activate sheet in QLIK SENSE?

Hello All,

Can someone help em telling how to make select a value in a filter when sheet is activated in QLIKSENSE.

My requirement is to select current month by default when the sheet is activated i qliksense.

Thanks,

Nikhil Garg

5 Replies
Chanty4u
MVP
MVP

you need to use 

sheetnavigator extension from Qlikbranch.com  triggers will work with that only.

bwisealiahmad
Partner - Specialist
Partner - Specialist

Another extension that is made for that is SheetEvents. Also found on Qlik Branch as Chanty4u already pointed out.

Check it out below:

Qlik Branch

nikhilgarg
Specialist II
Specialist II
Author

Hey,

But to use sheet navigator extension, i need to use button and when i explicitly click on the button then only trigger will be fired. But my requirement is:

When i click on any sheet and when that sheet gets activated, by default current month data should be shown.

nikhilgarg
Specialist II
Specialist II
Author

Hey,

But to use sheet navigator extension, i need to use button and when i explicitly click on the button then only trigger will be fired. But my requirement is:

When i click on any sheet and when that sheet gets activated, by default current month data should be shown.

Anonymous
Not applicable

Try using GetSelectedCount()

Let MonthYear be a date field with the format MM-YYYY

if (getselectedcount(MonthYear)=0, MonthYear='12-2017', MonthYear)

Add the same condition for the measure.

I had tried the same kind of filter for my app..

Default table:

default1.JPG

On adding filters:

default2.JPG