0 Replies Latest reply: Aug 27, 2012 2:30 PM by Tahir Ghalib RSS

    How to create Variables for Time?

      Hi All,

       

      Very new to QlikView.

       

      Here is the data fields (along several others related to users profile) available to me:

       

      1. Start Date-which is in following format 8/5/2012 12:00:00AM

      2. End Date-which is in following format 8/11/2012 12:00:00AM

      3. Page View Count (given in numbers)

       

      Data is not avaiable for every day rather it is weekly basis in which Start Date is the first day of the week whereas End Date is the last day of the week.

       

      My requirement is to show the users with folloiwng conditions:

      Pages viewed within 30 days > 15, Pages viewed within 7 days > 5

       

      How can I do that? Since the data is only available in date range (weekly), which object type I can use to generate my required report?

       

      Thanks,

       

      TA