topic Re: How To Calculate Item Wise Discount in QlikView

How To Calculate Item Wise Discount

Sun, 27 Jan 2013 04:35:08 GMT

I Have a Total DIscount Amount 500, And I Sale Three Item.

1.Item 1 Price - 2000.00

2.Item 2 Price - 1500.00

3.Item 3 Price - 2500.00

How To Calculate The Discount Amount Itemwise.

Result Should Be Like This:

1.Item 1 Price - 2000.00 Discount - 166.67

2.Item 2 Price - 1500.00 Discount - 125.00

3.Item 3 Price - 2500.00 Discount - 208.33

whiteline — Sun, 27 Jan 2013 12:37:24 GMT

1.Item 1 Price - 2000.00 Discount - 166.67 = 500*2000/(2000+1500+2500)

2.Item 2 Price - 1500.00 Discount - 125.00 = 500*1500/(2000+1500+2500)

3.Item 3 Price - 2500.00 Discount - 208.33 = 500*2500/(2000+1500+2500)

=TotalDiscount * Price / Sum (total Price)

Mon, 28 Jan 2013 06:28:03 GMT

please find attachement.

in script--

LOAD * INLINE [

sl, item, price

1, item1, 2000

2, item2, 1500

3, item3, 2500

];

then take pivot chart--

dimension--- sl and item

expressions--- (1) only(price)

(2) (price*500)/Sum(TOTAL(price))

then output show like this--