topic Numbers absent 2 weeks back in QlikView

Numbers absent 2 weeks back

Wed, 06 Jul 2011 13:06:43 GMT

Hi all,

I am working on an application in which I need to find all students which have been absent in the past 2 weeks.

So for example, I'm using the date 30/04/2011 as the End Date and want to flag all students that have been absent 2 weeks back.

So all Absent students from 16/03/2011 to 30/04/2011.

I would like to flag the absent student (Student Number), in the script load.

I have attached the sample .qvw I am working on.

Any idea would be appreciated!

Thank you

Wed, 06 Jul 2011 14:58:21 GMT

I've changed the example .qvw a little.

How could I show only dates between the 2 dates input in the Start Date and End Date input box?

I'd like to show only these dates in the chart/pivot.

Thanks

Thu, 07 Jul 2011 11:31:01 GMT

ideas?

Thu, 07 Jul 2011 15:30:20 GMT

I did some changes in your load script .

Hope that helps.

Philippe