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

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

Re: Deduct 7,14,21 days from one month

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

Highlighted
Creator
Creator

Re: Deduct 7,14,21 days from one month

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

Re: Deduct 7,14,21 days from one month

Hi Kumar,

check out the attachment.

MR

Highlighted
Creator
Creator

Re: Deduct 7,14,21 days from one month

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

Highlighted
Creator II
Creator II

Re: Deduct 7,14,21 days from one month

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

Highlighted
Partner
Partner

Re: Deduct 7,14,21 days from one month

Hi,

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