Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
In your expression, you can use '*':
Sum({<[field] = {'K10*'}>}Your_Value)
Maybe
=Only([field]) LIKE '*K10*'
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.
Thanks, but this doesn't work either when I type this in the Enable Conditional textbox.
Seems to work for me. You are selecting a single value, right? Or multiple values?
Can you upload a small sample QVW?
May be like this
Wildmatch(concat (distinct Field,'|'),*K10*')
Multiple values!
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?
Hi,
Maybe GetFieldSelections([ACA vendor_id]) like K10* ?
Mark