Solved: Re: Percent change compare to previous days per St... - Qlik Community

Anonymous · ‎2018-04-10

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

sunny_talwar · ‎2018-04-10

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)

sunny_talwar · ‎2018-04-10

May be check the attached app out

Anonymous · ‎2018-04-10

getting Error in Expression... I am, using version 11 maybe related?

sunny_talwar · ‎2018-04-10

Then I suggest using The As-Of Table

Anonymous · ‎2018-04-10

Thanks, so related to Qlik version?

sunny_talwar · ‎2018-04-10

Yes, the expression I used will only work on QlikView 12 or above

Anonymous · ‎2018-04-10

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?

vvira1316 · ‎2018-04-10

May be you can use previous() function in a similar way it is used in the following question

sunny_talwar · ‎2018-04-10

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

Anonymous · ‎2018-04-10

Great!

Yes Dates always ascending.

Many thanks

Percent change compare to previous days per Student