Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 

Change the sorting in Field Setting

Hi Everyone,

I will be grateful for your help -

I have field name TimeKeyMonthYear From calendar table,

The field include values in format: Month Year (January 2018).

I want that every time the application will open it will display as default the max value of field TimeKeyMonthYear,

and the user will get an option to change the selection but only to one selection.

Therefore I defined in field setting of field  TimeKeyMonthYear -> Always one selected value.

but the application choose the lowest month as default.

There is an option to change it so the default always will be the max value in field  TimeKeyMonthYear?


The calendar table :


TempDate As TIME_KEY,
TempDate As TimeKeyDate,
week(TempDate) As TimeKeyWeek,
Year(TempDate) As TimeKeyYear,
Month(TempDate) As TimeKeyMonth,
Day(TempDate) As TimeKeyDay,
'Q' & ceil(month(TempDate) / 3) As TimeKeyQuarter,
Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) As TimeKeyWeekYear,
MonthName(TempDate) As TimeKeyMonthYear,
WeekDay(TempDate) As TimeKeyWeekDay

//=== Generate a temp table of dates ===
date(mindate + IterNo()) AS TempDate
,maxdate // Used in InYearToDate() above, but not kept
WHILE mindate + IterNo() <= maxdate;

//=== Get min/max dates from Field ===/
min(FieldValue('TIME_KEY', recno()))-1 as mindate,
max(FieldValue('TIME_KEY', recno())) as maxdate


Thank you!




0 Replies