Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
The % should be calculated like (yesterday/(-1week-2week-3week))-1
regards
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