Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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