Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Creator
Creator

Re: subtract days from date column

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

regards

Highlighted
Specialist
Specialist

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