topic AW:HOW TO CALCULATE DISCOUNT ?? in QlikView

HOW TO CALCULATE DISCOUNT ??

Thu, 10 Mar 2011 07:54:31 GMT

I have a table called MATERIAL GROUP, which has various Material groups like 80FB, 83RT, 99FD, so on and so forth.

There are some groups, which have discounts in them.

How do i calculate the discount value in the material group table ?

So example,

There is a group which is MATERIAL GROUP:

80H2

80H3

80H4

80H5

80H6

80H7

80H8

80H9

80HA

80HB

(this is just a little bit of the groups), And of them, let us say, from 80H2 - 80H6 have a 30% discount, how do i calculate that price along with the whole group ?

AW:HOW TO CALCULATE DISCOUNT ??

brenner_martina — Thu, 10 Mar 2011 09:07:36 GMT

Hi,

best way is this expression:

Sum(quantity * price * (1 - If(match(Group,'80H2','80H3','80H4','80H5','80H6'), 0.3, 0)))

AW:HOW TO CALCULATE DISCOUNT ??

Thu, 10 Mar 2011 09:40:28 GMT

okay,but that means, must add in a new variable for quantity ? and how do you add the discount inside?

by the way the discount is 30%

Thanks!