Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

dynamic_girl
Contributor

requirement

i have a requirement :

I have below data:

   

field1field2
123123:None
456456:None
345345:None

now the values in colfield2 should be replaced with none ,

how to do that

20 Replies
qlik_aparnav
Contributor II

Re: requirement

Can you try

Purgechar(field2,'0123456789:') as newField

Highlighted
antoniotiman
Honored Contributor III

Re: requirement

SubField(field2,':',-1)

dynamic_girl
Contributor

Re: requirement

i have a requirement :

I have below data:

   

field1field2
123123:None
456456:None
345345:None

now the values in colfield2 should be replaced with NULL,

how to do that

qlik_aparnav
Contributor II

Re: requirement

On what condition it should be null?

prashantsanchet
Contributor

Re: requirement

SubField(field2,':',-1)

antoniotiman
Honored Contributor III

Re: requirement

Null() as field2

Re: requirement

Simply

Null() as FieldName OR

'' as FieldName

Not sure 100% i followed you?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
johnhhtp2
Contributor II

Re: requirement

try this,,,

NullTable:

Mapping Load None , Null() autogenerate 1;

Map subfield(Field2,':',2) using NullTable;

should be loaded before your original table...

dynamic_girl
Contributor

Re: requirement

filed2 displays value in above format against field1

so field 2 values should be null