Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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

14 Replies
sunny_talwar

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

Capture.PNG

sunny_talwar

I noticed that Period 6 repeared for Item = 01003 and Customer = 123... this is because the change happened in between the month.... so for the first 23 days the Price was 7.35 and then it changed to 7.1. But since the table box showed only Period, it showed both prices associated with Period 6. Is there a logic as to when the rate change actually takes place or is the above output the one you were looking for?

Capture.PNG

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

ooh this looks promising!

i will test it properly tomorrow.

Thanks very much Sunny

hopkinsc
Partner - Specialist III
Partner - Specialist III
Author

I am unsure on what sort of date field they want to use as yet, I have been waiting for a sample file from them for the last month!

I used the standard date but to be honest i think it will be linked to the period number instead, so i should only get 1 price if its linked on period

Will anything need to be changed if i change the link to period?

i haven't downloaded the QVW yet, i will do in the morning.

sunny_talwar

Are you saying that instead of receiving Price_Change file with a date, you might receive it with period? There will be a slight change, but let's just wait for the requirement to come through and then work on it.

Best,

Sunny