How to hard code a value for a field

[Anonymous]

Hi

is it possible to hard code a value based on a field weather the field is null or has some text in it?

I can see that you can do it like an if statement which works fine for example

if(Upper(CUST_REF) like 'BID*','Bidding',if(Upper(CUST_REF) like 'OTP*' or Upper(CUST_REF)='ORDER TO PLACE','Order to Place','Budget')) as [Q Type],

but i want to hard code CUST_REF weather if meets a criteria or not.

thanks

[Peter_Cammaert]

Script or User Interface?

[vishsaggi]

Can you provide what values are coming in your CUST_REF and what value you want to hard code based on what condition?

[pradosh_thakur]

If(len(trim(CUST_REF)) > 0, 'hardcode value 1', hardcode value 2')

[ger_alegria]

if(isnull(CUST_REF),0,1) as HardCodeField

[m_perreault]

**

If(len(trim(CUST_REF)) > 0, 'hardcode value 1', hardcode value 2')

[qlikviewwizard]

Hi,

Use this code.

if(WildMatch(CUST_REF,'BOST*'),'Bidding',

    if(WildMatch(CUST_REF,'OTP*','ORDER TO PLACE'),'Order to Place','Budget')) as [Q Type],