Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Deduct 7,14,21 days from one month

Hi,

I have one requirement like below

  

  dateVisitsUniqueorder
01-03-2015213476
08-03-2015447898
15-03-2015124576
22-03-2015098

675

From date column 7 days should be deducted continuously and measures(are calculated by count) also displayed according to that.

Thanks in advance

Regards,

Kumar

6 Replies
Anonymous
Not applicable
Author

What is the result you are looking to get? Do you have an example?

Anonymous
Not applicable
Author

Let's consider this month April. I want to display as below initially 1 day has to be deducted from current date. Then 7 days has to be deducted from yesterday like this . I want this either in straight table or pivot table

-3 week4-19-2015
-2 week4-26-2015
-1 week4-01-2015
Yesterday4-08-2015
mrossoit
Creator II
Creator II

Hi Kumar,

check out the attachment.

MR

Anonymous
Not applicable
Author

Hi,

I am new to this qlikview

Actually it is awesome, but in my requirement I have 8 expressions like visits, orders, pages.....

to get visits i have calculation like this below

=count({$<[Site Visit Hit Source]={"<>5,7,8,9"}, [Site Visit Post Page Event] = {0}>} [Visitor ID])

how do i put it in expressions. Can you explain to me and you have created 3 dimensions. For me also is it require to create 3 dimensions.

Regards,

kumar

mrossoit
Creator II
Creator II

Could you upload your qvw file explaining what is the final result you desire, please?

fvelascog72
Partner - Specialist
Partner - Specialist

Hi,

If you can calculate all the expressions in script you can use the attached file.