Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wajihakhan
New Contributor II

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

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

3 Replies
sushil353
Honored Contributor II

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

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);

adwitiya
Contributor

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

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.

Khan_Mohammed
Honored Contributor II

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

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.

Community Browser