Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

kumarreddy257
Contributor

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
kimrormark
Contributor

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

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

kumarreddy257
Contributor

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
mrossoit
Contributor II

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

Hi Kumar,

check out the attachment.

MR

kumarreddy257
Contributor

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

mrossoit
Contributor 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?

fvelascog72
Valued Contributor

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.

Community Browser