Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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) )
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) )