Incrementing a column.

QlikView_99 — Thu, 21 Nov 2019 10:15:21 GMT

Hi All,

I'm trying to increment a column based on the Admission date, there are some exams where each student should give for certain frequency, for ex if a student joined in 01/01/2015 and there is an exam called Personal Hygiene where he needs to write it every year and he needs to finish the exam after 5 days of exam assignment date where start date is first assignment date and the particular date in every following year is the next assignment date. so i need to find whether a student is pass for this year based on the above date. below is the practical problem for reference.

Student Name: Adam

Admission Date: 01/01/2015

Exams:

1.Personal Hygiene (this exam every student should write every year)

2.Insurance (this exam every student should write for every two years)

Days to complete the exam:

Personal Hygiene: 5 Days

Insurance: 30 Days

Date_Completed:

Personal Hygiene: 05/01/2018 (this exam is fail as he needs to write the exam every year and this years assignment date is 01/01/2019 so he needs to complete this by 05/01/2019 but he didnt even take the exam at all in this year so its a fail)

Insurance: 18/01/19 (this exam is pass because he'll get the exam assigned every two years and latest is 01/01/2019 and he needs to complete it in 30days, and he completed before that so its a pass).

Re: Incrementing a column.

Brett_Bleess — Wed, 04 Dec 2019 22:41:46 GMT

In these cases, you will generally get better responses if you can attach some sample data in a spreadsheet etc. as well as your expected output in the QVW, that helps folks better offer up suggestions for things. If you can add that, I suspect you may get some responses at that point, but right now it is a bit confusing I think.

Regards,
Brett

topic Re: Incrementing a column. in QlikView

Incrementing a column.

Re: Incrementing a column.