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: 
shannoypaul
Creator
Creator

To identify the most recent 2 bids from Excel Source

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

0 Replies