Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kumarreddy257
Contributor

subtract days from date column

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

2 Replies
kumarreddy257
Contributor

Re: subtract days from date column

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

regards

qlikpahadi07
Valued Contributor

Re: subtract days from date column

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 

Community Browser