Filtering dimensions that start with.....

[#1]

All,

I am new to qlikview and would like your help. I am trying to put a filter within a charts dimension. I want it to filter documents that start with specific document number.

I want to only see documents whose object_name start with the number "3215-QY......." a full document number looks like 3215-QYZ-001 and 3215-QYZ-002.

This is what I have been using and it doesn't work.

=if(object_name='3215-QY*',object_name)

Any help?

[maxgro · Accepted solution]

use wildmatch function in your calculated dimension

=if(wildmatch(object_name,  '3215-QY*'),object_name)

and flag suppress when value is null

[MarcoWedel]

or

=if(object_name like  '3215-QY*',object_name)