topic Re: Doubts about subfield function and if in QlikView

Doubts about subfield function and if

Mon, 03 Nov 2014 17:19:49 GMT

Hi everybody. Im working on an application and i´m having problems with an if statement.

I´ll put the code.

IF(Account'), '-', 2) = 'current', 'current', 'no current') AS Test

The accounts are like this 210453001-1-Current or 210453001-1-NoCurrent and i have to identify if they have the current or non current at the end, and put that on a new field.

Thank you all!

Greetings.

Re: Doubts about subfield function and if

MK_QSL — Mon, 03 Nov 2014 17:24:20 GMT

IF(Subfield(Account,'-',-1)='Current','Current','No Current') as Test

Re: Doubts about subfield function and if

Anonymous — Mon, 03 Nov 2014 17:25:12 GMT

You certainly have some typo's.

Put this as the expression in a Text Object

=subfield ( '210453001-1-Current' , '-', 3)

This will display 'Current' , so shows you need subfield 3 and not 2.