Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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?


1 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

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.

View solution in original post

3 Replies
jagan
Partner - Champion III
Partner - Champion III

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
Author

Thanks Jagan. It worked!

amita1621
Contributor III
Contributor III

Hi,

 

It doesn't works for me? Please help