To identify the most recent 2 bids from Excel Source

shannoypaul — Wed, 25 Nov 2020 16:16:04 GMT

Description:

The attached excel gives details about bids, bids can be of 2 types:

Direct
Indirect

The above is captured in field Bid Medium

Bid Medium decides which value to be used for the following computation

Direct (Bid Qty*Bid Direct Price)
Indirect (Bid Qty*Bid Indirect price)

Bids for the same Bid Item No. would be generated over a period, if the current bid have been set a higher price than the previous bid the Price Increase or Deviation Flag is set as 1.

Additionally, Bids can have step pricing i.e. Same Bid can have 2 different prices based on Qty (Row 6&7 in Excel).

Another computation is Deviation Amount-

(Bid Indirect Price(Current) - Bid Indirect Price(Previous))*Qty(Current)

For Step Pricing-

(Avg. Bid Indirect Price(Current) - Avg. Bid Indirect Price(Previous))*Qty(Current)

Whereas if the Bid Medium is Direct then for aforesaid computations we should use Bid Direct Price.

Problems faced:

To Identify the Previous Bid
To identify Step Pricing
To switch between Direct/Indirect Price

Kindly help me out with this, Thanks in advance.

Additional Details:

Key- Concatenation of (Bid Item No., Bid Cust. No., Bid Medium, Bid Cust.)

Message was edited by: Shannoy Paul

topic To identify the most recent 2 bids from Excel Source in QlikView

To identify the most recent 2 bids from Excel Source