Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to understand the sample script in the "Derived fields" (Link).
Calendar: DECLARE FIELD DEFINITION TAGGED '$date' Parameters first_month_of_year = 1 Fields Year($1) As Year Tagged ('$numeric'), Month($1) as Month Tagged ('$numeric'), Date($1) as Date Tagged ('$date'), Week($1) as Week Tagged ('$numeric'), Weekday($1) as Weekday Tagged ('$numeric'), DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear Tagged ('$numeric') Groups Year, Week, Weekday type drilldown as YearWeekDayName, Year, Month, Date type collection as YearMonthDate;
Could not find any document that explain what the "Groups" does.
I am looking at doing drilldown with the date field, so I want to understand the code on the "Groups" as "YearWeekDayName" seems to type as a drilldown.
Thanks.
Groups are currently not supported when declaring field definitions, as is seen in the syntax of the Declare help topic.
https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...
The inclusion of groups in the example is a mistake that we will correct in the next update of the help.
Thank you for bringing this to our attention, and apologies for the inconvenience.
Groups are currently not supported when declaring field definitions, as is seen in the syntax of the Declare help topic.
https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularS...
The inclusion of groups in the example is a mistake that we will correct in the next update of the help.
Thank you for bringing this to our attention, and apologies for the inconvenience.