Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Filtering dimensions that start with.....

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?

1 Solution

Accepted Solutions
MVP
MVP

Re: Filtering dimensions that start with.....

use wildmatch function in your calculated dimension

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

and flag suppress when value is null

2 Replies
MVP
MVP

Re: Filtering dimensions that start with.....

use wildmatch function in your calculated dimension

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

and flag suppress when value is null

Re: Filtering dimensions that start with.....

or

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

Community Browser