topic Re: Filtering dimensions that start with..... in QlikView

Filtering dimensions that start with.....

Wed, 03 Sep 2014 19:46:23 GMT

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?

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

maxgro — Wed, 03 Sep 2014 19:59:02 GMT

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.....

MarcoWedel — Wed, 03 Sep 2014 20:39:29 GMT

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