Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
twills12
Contributor III
Contributor III

new to Qlikview, suggestions on scripting logic

ID

ExerciseDateResult
ABCDExercise 112/1/2016Fail
ABCDExercise 201/16/2017Pass
ABCDExercise 303/02/2017Pass
ABCDExercise 404/15/2017Fail
ABCDExercise 505/22/2017Pass
ABCDExercise 606/01/2017Pass
ABCDExercise 707/18/2017Fail

Above is my sample data.  I want to be able to track test results by user (ID) within a time period.

If they fail the first time the 12 month review period begins.

On a second failure, they should be identified as 'Noted' and the 12 month review period starts over.

An additional failure within 12 months of 'Noted' should identify them as 'Review'.

I'm new to Qlikview, and would like any suggestions on how this could be scripted on my load to identify these phases per user while accounting for the time period as well.

0 Replies