subtract days from date column

[Anonymous]

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

[Anonymous]

The % should be calculated like (yesterday/(-1week-2week-3week))-1

regards

[qlikpahadi07]

if you need 4 weeks of data which is fix  you can achieve that by simply creating a inline table for those 4 data entry then using SET analysis with if condition.

might be helpful