topic Change data value in QlikView

Change data value

gerhardl — Thu, 21 Apr 2011 10:41:58 GMT

Hi,

I have a field called [Decision Result]. Value would be eithe A or D.

How can I change my script to show A as "Approved" and D as "Declined"?

Thanks,

suniljain — Thu, 21 Apr 2011 10:47:22 GMT

if(Decision ='A','Active'.

if(Decision = 'D'.'Declined')) as Decision_Type

pat_agen — Thu, 21 Apr 2011 10:47:56 GMT

hi,
there are many ways but the easiest is simply adding a new field (or replacing your existing field) like this

load

if( [Decision Result]='A','Approved',
if( [Decision Result]='D','Declined')) as [Decision Result]
....

if you have more complex transformations mapping tables are the way to go, look them up with the search facility.

hope this helps

Thu, 21 Apr 2011 10:49:43 GMT

Try

if ( [Decision Result] = 'A', 'Approved', 'Declined') as [Decision Result],

Regards

Anders