Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
r20017aaa
Creator III
Creator III

Percent change compare to previous days per Student

Is it possible  in Qlikview to get the percentage of change of a grade compare to previous days per student?

so from

2.png

....

to get

% change compare to 1 day ago% change compare to 2 days ago% change compare to 3 days ago

so:

1.png

Many thanks.

Raphael

1 Solution

Accepted Solutions
sunny_talwar

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)

View solution in original post

16 Replies
sunny_talwar

May be check the attached app out

Capture.PNG

r20017aaa
Creator III
Creator III

getting Error in Expression... I am, using version 11 maybe10-04-2018 15-09-59.png related?

sunny_talwar

Then I suggest using The As-Of Table

r20017aaa
Creator III
Creator III

Thanks, so related to Qlik version?

sunny_talwar

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

The sortable Aggr function is finally here!

r20017aaa
Creator III
Creator III

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
Specialist II
Specialist II

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

Comparing alarm of a period and previous period

sunny_talwar

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

r20017aaa
Creator III
Creator III

Great!

Yes Dates always ascending.

Many thanks