How to set the whole app/dashboard to current year and month as default?

[Anonymous]

Hi

How can i set the whole app/ dashboard to current year and month as default?

On opening an app or any sheet user will see the current year and month data but on selection it should change too.

Thanks

[sushil353]

you can use variable for year and month and then pass this variable in all of your expressions:

vMaxYear = Max(Year);

vMaxMonth = Max(Month)

Sum({<Year={$(vMaxYear),Month={<$(vMaxMonth)>}}>}Sales);

[Anonymous]

Use something like this as a measure:

if(getselectedcount(Year)=0,

     sum({<Year={2017}>}Measure),

     sum(Measure))

Change the code according to your requirements, but this should be the basic logic.

Let me know if this was helpful.

[MK9885]

Sheet Navigation extension can be used...

http://branch.qlik.com/#!/project/56728f52d1e497241ae698a0

There are no inbuilt triggers in Qlik Sense. In the extension, Actions use Select a value in field. Set it to Max year and Current Month.