Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible in Qlikview to get the percentage of change of a grade compare to previous days per student?
so from
....
to get
% change compare to 1 day ago | % change compare to 2 days ago | % change compare to 3 days ago |
so:
Many thanks.
Raphael
Then try this
=Aggr(If(Dates = Above(Dates)+1, Sum(Grades)/Above(Sum(Grades))-1, 0), Students, Dates)
=Aggr(If(Dates = Above(Dates, 2)+2, Sum(Grades)/Above(Sum(Grades), 2)-1, 0), Students, Dates)
May be check the attached app out
getting Error in Expression... I am, using version 11 maybe related?
Then I suggest using The As-Of Table
Thanks, so related to Qlik version?
Yes, the expression I used will only work on QlikView 12 or above
thank you, I has a look at the
Link you sent about as of table, not sure yet how that can help, is there any other way?
May be you can use previous() function in a similar way it is used in the following question
Is it possible to make sure to sort the Dates in ascending order in script, if this can be done, then yes there is another way
Great!
Yes Dates always ascending.
Many thanks