Discussion board where members can get started with Qlik Sense.
I have this data:
load * inline
["StudentID", "Level", "Programme", "EnrollmentID", "FromDate"
And want a table in Qlik Sense, which shows the same data with two additional columns:
EnrollmentSequence = for each individual StudentID a running sequence (1,2, etc.) for each StudentID with same Programme and Fromdate.
NumberOfEnrollements= The max number of EnrollmentSequence for each StudentID
My desired table should look like this:
All ideas are welcome. I would prefer solutions in chart expression. But options in load script are also very welcome.
StudentID&'-'&Programme&'-'&FromDate as KEY,
AutoNumber(RecNo(),AutonumberHash128(StudentID,Programme,FromDate)) as Sequence
"StudentID", "Level", "Programme", "EnrollmentID", "FromDate"
Max(Sequence) as Max_Sequence
Group by KEY;
View solution in original post
Thanks, it works fine.
Any ideas on how I could do the same in a chart expression (table)?