Writing if else statement in expression and/or script

[#1]

Hi,

I am very new to QV and so I am having little trouble in doing something that is a small extension of the problem originally posted by Andrew.

What I want is, I want to show say, kick-back for each customer by multiplying the sales with kick-back rate. For example, if Customer is Bob then Sales * 16.2 else if customer is Karla then Sales * 11.0.

Something like this:

dimension  = Customer kick back
expression = sum({<Customer={'Bob'}>} Sales*16.2, else if {<Customer={'Karla'}>} Sales*11.0, else Sales*9.0 )

How can I achieve this?

[jagan · Accepted solution]

Hi Syed,

Use AGGR function to achieve this as shown below.

Sum(Aggr(If(Customer='Bob',  Sum(Sales)*16.2,

         If(Customer='Karla', Sum(Sales)*11.0, Sum(Sales)*9.0))))

Regards,

Jagan.

[#3]

Thanks Jagan. It worked!

[amita1621]

Hi,

It doesn't works for me? Please help