Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

tekst selection in If statement

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

2 Replies
Not applicable
Author

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

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