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.
you need to use
sheetnavigator extension from Qlikbranch.com triggers will work with that only.
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.
Another extension that is made for that is SheetEvents. Also found on Qlik Branch as Chanty4u already pointed out.
Check it out below:
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..
On adding filters:
Retrieving data ...