Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one requirement like below
date | Visits | Unique | order |
01-03-2015 | 21 | 34 | 76 |
08-03-2015 | 44 | 78 | 98 |
15-03-2015 | 12 | 45 | 76 |
22-03-2015 | 0 | 98 | 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
What is the result you are looking to get? Do you have an example?
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 week | 4-19-2015 |
-2 week | 4-26-2015 |
-1 week | 4-01-2015 |
Yesterday | 4-08-2015 |
Hi Kumar,
check out the attachment.
MR
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
Could you upload your qvw file explaining what is the final result you desire, please?
Hi,
If you can calculate all the expressions in script you can use the attached file.