topic subtract days from date column in QlikView

subtract days from date column

Anonymous — Fri, 10 Apr 2015 06:07:35 GMT

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

Re: subtract days from date column

Anonymous — Fri, 10 Apr 2015 09:16:11 GMT

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

regards

Re: subtract days from date column

qlikpahadi07 — Fri, 10 Apr 2015 09:36:58 GMT

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