Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

datalakeyu
Valued Contributor

How to set default date range in Qlik Sense with Set Analysis or other methods?

I use DateRangePicker from Qlik branch:

http://branch.qlik.com/#!/project/5697a878dcc497f80ed514bf

I would like to set the default date range from the first day of current year to current date.

Is it possible to set default date range from the first day of current year to current date with “Set Analysis” or other methods with Qlik Sense?

Any suggestion is appreciated! 

1 Solution

Accepted Solutions
datalakeyu
Valued Contributor

Re: How to set default date range in Qlik Sense with Set Analysis or other methods?

Figure out a walking around solution: to use if condition and set analysis, such as the following:

If(GetSelectedCount(myDate), Sum (myValue),  Sum({$ <  myDate *= {">=$(=Date(Yearstart(Today()),'MM/DD/YYYY'))<=$(=Date(Today(),'MM/DD/YYYY'))"} >} myValue)    )

1 Reply
datalakeyu
Valued Contributor

Re: How to set default date range in Qlik Sense with Set Analysis or other methods?

Figure out a walking around solution: to use if condition and set analysis, such as the following:

If(GetSelectedCount(myDate), Sum (myValue),  Sum({$ <  myDate *= {">=$(=Date(Yearstart(Today()),'MM/DD/YYYY'))<=$(=Date(Today(),'MM/DD/YYYY'))"} >} myValue)    )

Community Browser