Using Wildcard filtering Dimension values in pivot table

[ingoniclas]

I want to have fields to be displayed in a pivot table only if certain contitions are met. For example, I only want [field] to be displayed if a user selects a value that contains 'K10'. Therefore, I went to Chart Properties -> Dimensions -> Enable Conditional, and I typed in:

[field] = 'K10*'

But this does not work. It works w/o he asterik, but I want to filter for any vaule containing K10. Does * not work as a wildcard here?

[sinanozdemir]

In your expression, you can use '*':

Sum({<[field] = {'K10*'}>}Your_Value)

[swuehl]

Maybe

=Only([field]) LIKE '*K10*'

[ingoniclas]

Thanks, but this is not what I had in mind. I virtually want a dimension to vanish from the pivot table unless a value including K10 is selected.

[ingoniclas]

Thanks, but this doesn't work either when I type this in the Enable Conditional textbox.

[swuehl]

Seems to work for me. You are selecting a single value, right? Or multiple values?

Can you upload a small sample QVW?

[settu_periasamy]

May be like this

Wildmatch(concat (distinct Field,'|'),*K10*')

[ingoniclas]

Multiple values!

[ingoniclas]

Your formula works for me too when I select only ONE value that includes K10, but I need a solution that works in case I select multiple values including K10. Any ideas?

[Mark_Little · Accepted solution]

Hi,

Maybe GetFieldSelections([ACA vendor_id]) like K10* ?

Mark