Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us on May 23rd, Q&A with Qlik - Developer Series, Customizing Extensions: Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Mch201
Contributor III
Contributor III

How to only display grades that dropped the most in QlikSense?

Lets say I have data which includes the student name, week number & their weekly grades. This data is updated every week.

I want to create a chart which will only show the student whos grades dropped more than 30% from the past week. 

for ex. 

StudentWeek Grade
Brian177
Brian267
Brian386
Brian468
Brian566
Brian683
Brian827

 

In this example, the students grade dropped significantly(over 30%) in week 8. We want to be able to see all students whos grades have dropped more than 30%, just like in this example.

 

 

How would I go about doing this?

Labels (3)
3 Replies
Saravanan_Desingh

One solution is:

tab1:
LOAD *, If(Diff>30, 'Red') As Status;
LOAD *, If(Student=Peek(Student), Peek(Grade)- Grade) As Diff;
LOAD * INLINE [
    Student, Week , Grade
    Brian, 1, 77
    Brian, 2, 67
    Brian, 3, 86
    Brian, 4, 68
    Brian, 5, 66
    Brian, 6, 83
    Brian, 8, 27
];
Saravanan_Desingh

Output:

commQV83.PNG

Rodj
Luminary Alumni
Luminary Alumni

Another idea, if you want to do this just in a straight table without modifying your script, create the table with Student and Week and ordered by Student and Week. Then create a measure like:

=if((Above(Sum(Grade)) - Sum(Grade)) / Above(Sum(Grade)) >= .3, (Above(Sum(Grade)) - Sum(Grade)) / Above(Sum(Grade)), 0)

In the Add-ons --> data handling property of the table uncheck "Include zero values".