topic How to add a default value in QlikView

How to add a default value

abc_18 — Tue, 24 Jul 2018 10:26:34 GMT

Hi,

In our script we are generating one field value using below script:-

if(left(bkey_bd_company,1)='#','CFN','BD') as "NEWCO id"

NEWCO id

CFN

Now the requirement is to add another value as by default 'BARD'. so the user should be able to see values as if none of the above condition is true:-

NEWCO id

CFN

BARD

Re: How to add a default value

tresB — Tue, 24 Jul 2018 10:50:28 GMT

You have already defined the ELSE part in your expression and it is returning DB as default. To have another value as default, you must have at least one more condition, like:

You have now :

If ( XX='Cow', 'Animal', 'Not-animal')

To have default third value, you would need something like:

If( XX='Cow', 'Animal', If( XX='Tree', 'Tree', 'Neither animal nor tree'))