Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
you need to use
sheetnavigator extension from Qlikbranch.com triggers will work with that only.
Another extension that is made for that is SheetEvents. Also found on Qlik Branch as Chanty4u already pointed out.
Check it out below:
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.
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.
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:
On adding filters: