Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
ajsjoshua
Specialist
Specialist

Week Comparison Problem

Hi all,

I want to compare the orders for all weeks

I have two years of data 2015 and 2016

i am unable to compare 52 week of 2015 and 8 week of 2016.

i am using this expression

=sum({<Year_UP = {$(=Max(Year_UP))},Week_UP = { $(=Max(Week_UP)-8) },Week = {"=$(=Max(Week_UP))"},Year=,Month=,Quarter=>}Orders)

Regards,

Joshua.

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Create a Straight/Pivot Table

Dimension

Week_UP

Expression

=SUM({<Week_UP = {"=Week_UP + 8 = Week"}>}Orders)

View solution in original post

28 Replies
MK_QSL
MVP
MVP

Not understood what exactly you want to do... can you explain in brief please..

ajsjoshua
Specialist
Specialist
Author

Hi Manish,

Pls find the sample attached.

ajsjoshua
Specialist
Specialist
Author

Hi mrkachhiaimp



Bro actually if user select week 8 in Year=2016 it should show orders value  for week 8 which has been forecasted on 52 week of year 2015 .

MK_QSL
MVP
MVP

I still don't get the logic. Can you explain by taking two examples... say select Week 10 and what result you are expecting.. Select week 20 and provide the result you are looking for..

ajsjoshua
Specialist
Specialist
Author

Hi mrkachhiaimp

If i select Week_Up=10 then it should display orders for week 10 which has been forecasted on week_Up=2

If i select Week_Up=20 then it should display orders for week 20 which has been forecasted on week_Up=12


Its working fine  for these two but its not giving answers for week_Up =8

week_Up =7

week_Up =6

week_Up =5

week_Up =4

week_Up =3

week_Up =2

week_Up =1

MK_QSL
MVP
MVP

But also provide output... I mean sum(orders) you are looking for..

ajsjoshua
Specialist
Specialist
Author

Hi,

For week_up=20

Forecasted 8 orders=380.8796

MK_QSL
MVP
MVP

Create a Straight/Pivot Table

Dimension

Week_UP

Expression

=SUM({<Week_UP = {"=Week_UP + 8 = Week"}>}Orders)

ajsjoshua
Specialist
Specialist
Author

Hi mrkachhiaimp

I am not getting any values.

Regards,

Joshua.