Hello, Your date format is DD / MM / YYYY hh: mn: ss
SET TimeFormat = 'h: mm: ss TT'; SET DateFormat = 'M / D / YYYY'; SET TimestampFormat = 'M / D / YYYY h: mm: ss [.fff] TT'; SET MonthNames = 'Jan; Feb; Mar; Apr; May; Jun; Jul; Aug; Sep; Oct; Nov; Dec'; SET DayNames = 'Mon; Tue; Wed; Thu; Fri; Sat; Sun';
If your date field starts in 2016 you have to create MinDate and MaxDate with Makedate Example LET vMinDate = Num (Makedate (2015,1,1)); LET vMaxDate = Num (Makedate (2017, 12,31)); You can also use either autocalendar from QS or MasterCalendar
Well, that really depends on what you're looking to build. I'm still a little confused as to what it is that you want to do.
You can create filter panes and simply have the user viewing the app make selections in the filter pane to view the year, month, week, or data that they want to view. And these selections that the user makes will be apply throughout the entire Qlik Sense app/dashboard. This would be the easiest if you don't want to do a lot of scripting.
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.