topic Re: function IF in QlikView

function IF

roger0802 — Fri, 20 Mar 2015 11:26:55 GMT

Hi to everybody,

Maybe it's a sample question..

is it possible to make a function IF with text, NOT number?

or is there something similar?

example:

if([namefield]=N,a,b)

THANK YOU VERY MUCH!

Ruggero

Re: function IF

MK_QSL — Fri, 20 Mar 2015 11:27:45 GMT

if([namefield]='N','a','b') as [namefield]

Re: function IF

Fri, 20 Mar 2015 11:55:11 GMT

Hi,

Just use the quotation marks to identify the text field.

Ex:- if([namefield]=' N ',a,b)

See the 'N' in your expression.

Priyantha.

Re: function IF

nikhilgarg — Fri, 20 Mar 2015 11:59:54 GMT

Hey,

But i think if([namefield]='N','a','b') as [namefield] will also work fine. Isn't it ?

Re: function IF

buzzy996 — Fri, 20 Mar 2015 12:46:23 GMT

u have to try like this,

if([namefield]='N','a','b')

Re: function IF

Fri, 20 Mar 2015 12:53:17 GMT

Hi,

not only number text also can work

Ex:

=if([namefield]='N','a','b') as [namefield])

here, N means some text

Re: function IF

tcullinane — Fri, 20 Mar 2015 12:59:20 GMT

use

if(match([namefield],'N'),'a','b') as [namefield]

match, wildmatch etc are handy for text.

Re: function IF

roger0802 — Fri, 20 Mar 2015 13:57:41 GMT

Really thank you to everybody!

Ruggero

Re: function IF

Anonymous — Fri, 20 Mar 2015 14:05:48 GMT

Could you please close this thread by marking the correct answer? And maybe helpful answers as well?

It will give the deserved points to the "answerers", and will help those who use search.

Re: function IF

roger0802 — Fri, 20 Mar 2015 14:11:25 GMT

You're right..