Discussion Board for collaboration on QlikView Scripting.
I have a table that present for each question the user answer and the number of attempt he made for this question, see example table:
I would like to present for each user and question only his last attempt,
i know i need to use aggr and max functions so how, but i wasn't able to find the solution, can someone help?
FirstSortedValue([User Code],-Aggr([Quiz Attempt Number],[Quiz Question],User Code)) >>>>> results in User Code
Edited - there was two commas after Quiz Question:
FirstSortedValue([Quiz Question],-Aggr([Quiz Attempt Number],[Quiz Question],User Code))>>>>> results in Quiz Question