This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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)?