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: 
hopkinsc
Partner - Specialist III
Partner - Specialist III

Help with adding in a price change file and using the new prices

Hi all,

I have a requirement that i have no idea how to implement.

I have some forecast data which is by Customer, Item and Period. I then have left joined the standard item prices to the forecast data.

This then allows me to use the forecast volume * the standard price to get a forecast value.

What i need is it to take into account a price change file, so for example..

for Item 01003 and customer 123 i would have the following forecast values

  

PeriodForecast Value
150
2201
3150
4150
5150
6130
7130
8130
9100
10100
11100
12400
13250

The standard price for this Item and this customer is 7.35

but in period 6 there will be a price change, the new price will be 7.10.

so what i need is to use the 7.35 for period 1-5 then 7.10 there after.

    

PeriodForecast QtyPriceForecast Value
1507.35367.5
22017.351477.35
31507.351102.5
41507.351102.5
51507.351102.5
61307.1923
71307.1923
81307.1923
91007.1710
101007.1710
111007.1710
124007.12840
132507.11775

I would appreciate any help given

1 Solution

Accepted Solutions
sunny_talwar

Finally, I made myself motivated to do this... check it out

Capture.PNG

View solution in original post

14 Replies
sunny_talwar

Looks like a great candidate for Interval Match.... have you tried that?

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Hi Sunny,

I haven't yet, I am unsure how to get the calculations to take the correct price based on the period..

sunny_talwar

Is period linked to date? How do you know that P6 is when change happen. Because change is based on date 5/24/2018

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Yes, it is linked to date. so if you were to select the 24th May, this will filter to P6

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Morning Sunny,

did you have any thoughts on this?

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

morning Sunny,

I don't suppose you've had a chance to think about how i can do this have you?

sunny_talwar

Today will be the day... will def. get back to you sometime today.

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Hi Sunny, I don't suppose you have had any luck with this?

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

Can anyone help with this?