topic Re: How to hard code a value for a field in QlikView

How to hard code a value for a field

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Thu, 24 May 2018 16:07:31 GMT

Script or User Interface?

vishsaggi — Thu, 24 May 2018 19:25:35 GMT

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 — Thu, 24 May 2018 19:44:30 GMT

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

ger_alegria — Thu, 24 May 2018 21:17:52 GMT

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

m_perreault — Thu, 24 May 2018 22:25:56 GMT

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

qlikviewwizard — Fri, 25 May 2018 02:23:00 GMT

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],