Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I tried the derived calendar and I couldn't get the group dimensions to show up. I even downloaded Michaels app from Qlik Sense 1.1 is Available but that didn't have the groups either. Is this a bug?
I understand it's just groundwork for stuff to come but one improvement would be if you only have one derived calendar it would only show the field name instead of OriginalField.Table.Field.
Really hoping for a good date selection tool.
Hi guys - here is the deal with the Groups syntax - that is reserved for a future feature - where it has been implemented in the back-end, but not yet exposed in the UI. There was a mistake adding that in the sample code in the documentation, and it is being updated. The Groups feature will be available in a future release - where it will automatically create the collection and cyclic groups for those specified fields.
Hope this helps.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike Tarallo
Qlik
The drill-down and collections groups, YearWeekWeekDay & YearMonthDate doesn't show up under dimensions in the asset library.
Yes it's true, i also want to know clearly about Group area,
i added two drive fields so the group functionality how many drill group will create ????
Yeah, even the example script in the help does not create groups.
Here is a sample script
-----------------
Calendar:
DECLARE FIELD DEFINITION TAGGED '$date'
Parameters
first_month_of_year = 1
Fields
Year($1) As Year Tagged '$year',
Month($1) as Month Tagged '$month',
MonthName($1) as MonthName Tagged '$monthname',
Date($1) as Date Tagged ('$date', '$day'),
Week($1) as Week Tagged '$week',
WeekName($1) as WeekName Tagged '$weekname',
Weekday($1) as Weekday Tagged '$weekday',
DayNumberOfYear($1, first_month_of_year) as DayNumberOfYear
Groups
Year, Week, Weekday type drilldown as YearWeekDayName,
Year, Month, Date type collection as YearMonthDate;
DERIVE FIELDS FROM FIELDS "Claim Creation Date" USING Calendar;
here it is with the colored script coding for effect:
-------------------
Earlier in the script i loaded a table with the name "Claim Creation Date"
ex:
LOAD
"Claim Creation Date",
...
from ....
------------------------
Here is a screen snippet of the result in the UI
---------------
Totally agree with the comment about controlling the names to be shorted of the derived fields. Feedback has been submitted.
Hi guys - here is the deal with the Groups syntax - that is reserved for a future feature - where it has been implemented in the back-end, but not yet exposed in the UI. There was a mistake adding that in the sample code in the documentation, and it is being updated. The Groups feature will be available in a future release - where it will automatically create the collection and cyclic groups for those specified fields.
Hope this helps.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.
Regards,
Mike Tarallo
Qlik
Hi Michael,
I'm gutted!
What release is this expected in? I presume that the "collection" type is the introduction of cyclic groups to Sense?
Regards,
Stephen
Hi Stephen - LOL - sorry. You are correct, however I do not have a release number or date on this.
If I hear something sooner, I'll PM you.
Mike
Mike, thanks for answering this as I found the same issue. Look forward to this being fixed in the next version