2 Replies Latest reply: Apr 10, 2015 5:36 AM by Rohit Koul RSS

    subtract days from date column

    kumar avisakula

      Hi,

      I am new to qlikview and below screen shot is my requirement.

      From Time Full Date column -1 days should be deduct that will give yesterdays date. From yesterdays date again 7 days should be deduct and in same way again 7 days should be deduct from previous result. Like this I need 4 weeks of data like below.

       

      I am calculating this Unique vistors, Visits, page views, orders by

       

      =count(DISTINCT{$<[Geography Country]={'usa'},[Site Visit Hit Source]={"<>5,7,8,9"}, [Site Visit Post Page Event] = {0}>} [Visitor ID])

      like this for rest of expressions

       

       

      Regards,

      kumar