topic Re: Using Wildcard filtering Dimension values in pivot table in QlikView

Using Wildcard filtering Dimension values in pivot table

ingoniclas — Tue, 10 Nov 2015 20:56:40 GMT

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?

Re: Using Wildcard filtering Dimension values in pivot table

sinanozdemir — Tue, 10 Nov 2015 21:22:49 GMT

In your expression, you can use '*':

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

Re: Using Wildcard filtering Dimension values in pivot table

swuehl — Tue, 10 Nov 2015 21:24:05 GMT

Maybe

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

Re: Using Wildcard filtering Dimension values in pivot table

ingoniclas — Tue, 10 Nov 2015 21:37:29 GMT

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.

Re: Using Wildcard filtering Dimension values in pivot table

ingoniclas — Tue, 10 Nov 2015 21:38:17 GMT

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

Re: Using Wildcard filtering Dimension values in pivot table

swuehl — Tue, 10 Nov 2015 21:59:17 GMT

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

Can you upload a small sample QVW?

Re: Using Wildcard filtering Dimension values in pivot table

settu_periasamy — Tue, 10 Nov 2015 22:04:40 GMT

May be like this

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

Re: Using Wildcard filtering Dimension values in pivot table

ingoniclas — Wed, 11 Nov 2015 09:13:54 GMT

Multiple values!

Re: Using Wildcard filtering Dimension values in pivot table

ingoniclas — Wed, 11 Nov 2015 09:24:15 GMT

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?

Re: Using Wildcard filtering Dimension values in pivot table

Mark_Little — Wed, 11 Nov 2015 09:25:26 GMT

Hi,

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

Mark

Re: Using Wildcard filtering Dimension values in pivot table

ingoniclas — Wed, 11 Nov 2015 09:29:34 GMT

Mark, many thanks! This works well for me!

Re: Using Wildcard filtering Dimension values in pivot table

ingoniclas — Wed, 11 Nov 2015 10:12:38 GMT

There is one question left - what if I want this to work for additional values say K10* AND U20*? I tried the following, but it didn't work:

GetFieldSelections([field]) like 'K10*' OR *U20*'

GetFieldSelections([field]) like 'K10*' AND *U20*'

Any ideas?

Re: Using Wildcard filtering Dimension values in pivot table

swuehl — Wed, 11 Nov 2015 10:26:44 GMT

=GetFieldSelections([field]) like 'K10*' AND GetFieldSelections([field]) like '*U20*'

Re: Using Wildcard filtering Dimension values in pivot table

ingoniclas — Wed, 11 Nov 2015 10:36:50 GMT

I figured that out by myself in the meantime, but many thanks anyway Stefan.

Re: Using Wildcard filtering Dimension values in pivot table

Anonymous — Wed, 11 Nov 2015 13:39:29 GMT

Thanks Gysbert..