topic Re: How to use decode function in expression in QlikView

How to use decode function in expression

Sat, 28 Jun 2014 06:14:51 GMT

Hello,

Please tell me how can I use the decode function in QlikView as we use in SQL.

Like in sql I write:

sum(SELLING_PRICE)/decode(sum(NUM_DEVICES),0,1,sum(NUM_DEVICES))/1000

How can I write this in QlikView expression?

Thanks in advance for your time.

Regards

selvakumarsr — Sat, 28 Jun 2014 06:22:40 GMT

No you cannot use decode function in expression

Selva

PrashantSangle — Sat, 28 Jun 2014 06:39:46 GMT

Hi,

Yes you can not use decode function in Qlikview but

You can use if -else as alternative to decode

Use like this,

sum(SELLING_PRICE)/if(sum(NUM_DEVICES)=0,1,sum(NUM_DEVICES))/1000

If(sum(NUM_DEVICES)=0,SUM(SELLING_PRICE),

SUM(SELLING_PRICE)/SUM(NUM_DEVICES)

)/1000

Regards

Sat, 28 Jun 2014 18:42:12 GMT

Thanks Max !