Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

tekst selection in If statement

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

tekst selection in If statement

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