topic tekst selection in If statement in QlikView

tekst selection in If statement

Wed, 05 Oct 2011 08:23:18 GMT

Hello,

I want to display a table with certain order numbers in it.

I would like to do this using de If function.

Are made up through the following format :

IPMOR11-0778

IPMRC10-0004

IPMOF10-0001

I would like the table only to show the order containing IPMOR.

Can anybody help me with this ?

Thanks

Thu, 06 Oct 2011 12:56:49 GMT

Hello,

I suppose you want to use a calculated dimension. Lets call the field "Account Name" and create the dim like this:

=if( Left([Account Name],5) = 'IPMOR', [Account Name])

Regards,

Roland

its_anandrjs — Thu, 06 Oct 2011 13:01:50 GMT

Hi,

Try the below code

=If( Match([Account Name],Left([Account Name],5) = 'IPMOR') , [Account Name] )

To check IPMOR only in the expression or table.

Rgds
Anand