topic Re: Code in QlikView

Code

deepakqlikview_123 — Wed, 21 May 2014 12:06:54 GMT

Hi all,

Can you please suggest what would be optimized code for code given below.

if(FuelType='Diesel' or FuelType='DIESEL','Diesel',If(FuelType='LPG','LPG',If(FuelType='CNG','CNG')))as FuelType

If fuel type is Diesel or DIESEL then i need to display DIESEL or if fuel type is CNG then CNG and if LPG then LPG.

Thanks,

Deepak

its_anandrjs — Wed, 21 May 2014 12:09:51 GMT

You can try with

if(Match(FuelType='Diesel','DIESEL'),'DIESEL',

If(Match(FuelType='LPG'),'LPG',

If(Match(FuelType='CNG'),'CNG'))) as FuelType

preminqlik — Wed, 21 May 2014 12:23:00 GMT

Load *,

upper(trim(FuelType) ) as NewFuelType

from path;

its_anandrjs — Wed, 21 May 2014 12:39:11 GMT

Another way is

Load

Trim(if(Match(FuelType='Diesel','DIESEL'),'DIESEL',

If(Match(FuelType='LPG'),'LPG',

If(Match(FuelType='CNG'),'CNG'))) ) as FuelType

From Location;

deepakqlikview_123 — Thu, 22 May 2014 04:52:53 GMT

Hi Anand,

It is giving me syntax error.

NareshGuntur — Thu, 22 May 2014 07:18:51 GMT

Hi Deepak,

Try this

if(Upper(FuelType)='DIESEL','DIESEL',if(Upper(FuelType)='LPG','LPG',if(Upper(FuelType)='CNG','CNG')))

anbu1984 — Thu, 22 May 2014 08:39:05 GMT

=if(Match(FuelType,'Diesel' ,'DIESEL','LPG','CNG'),Upper(FuelType))