topic Writing if else statement in expression and/or script in QlikView

Writing if else statement in expression and/or script

Tue, 08 Nov 2011 09:41:36 GMT

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?

Writing if else statement in expression and/or script

jagan — Tue, 08 Nov 2011 10:52:57 GMT

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.

Writing if else statement in expression and/or script

Tue, 08 Nov 2011 10:58:51 GMT

Thanks Jagan. It worked!

Re: Writing if else statement in expression and/or script

amita1621 — Fri, 18 Oct 2019 10:44:59 GMT

Hi,

It doesn't works for me? Please help