Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

nikhilgarg
Contributor III

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
sureshqv
Esteemed Contributor III

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

you need to use 

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

bwisealiahmad
Valued Contributor

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

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
Contributor III

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

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
Contributor III

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

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.

adwitiya
Contributor

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

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