Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
use wildmatch function in your calculated dimension
=if(wildmatch(object_name, '3215-QY*'),object_name)
and flag suppress when value is null
use wildmatch function in your calculated dimension
=if(wildmatch(object_name, '3215-QY*'),object_name)
and flag suppress when value is null
or
=if(object_name like '3215-QY*',object_name)