Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Writing if else statement in expression and/or script

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?


Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Writing if else statement in expression and/or script

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.

2 Replies
MVP
MVP

Writing if else statement in expression and/or script

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.

Not applicable

Writing if else statement in expression and/or script

Thanks Jagan. It worked!

Community Browser