topic Need expression in QlikView

Need expression

Thu, 12 Dec 2013 09:28:31 GMT

how can i calculate payout for a customer.my payout is depend upon delay days

Data provided 1-10 calendar days late: deduction in Fees of ten percent (10 %)
Data provided 11-20 calendar days late: deduction in Fees of twenty percent (20 %)
Data provided 21-30 calendar days late: deduction in Fees of thirty percent (30 %)
Data provided 31-90 calendar days late: deduction in Fees of fifty percent (50%)
Data provided more than 90 calendar days late: no Fees due

how can i get these any suggestion would be helpful

Re: Need expression

datanibbler — Thu, 12 Dec 2013 09:33:14 GMT

Hi Kannuri,

easy:

- You can easily calculate the payout with a discount by just multiplying it by 0.9 (10% deduction) etc.

- You can calculate the days_of_delay by subtracting the cutoff_date from the provided_date (that will give you a nr. of days)

=> Then you just have to construct an IF_construction. With your five possibilities, a PICK(MATCH) construct might be more performant, but for that you'd have to take the extra step of making categories. Try with IF for starters.

HTH

Best regards,

DataNibbler