topic Re: Wildcard Across Fields?? Is it possible. in QlikView

Wildcard Across Fields?? Is it possible.

bnelson111 — Tue, 07 Jul 2015 14:18:33 GMT

Here is a strange request, I am currently trying to select a wild card match which is working on a single field.

if(wildmatch(PSADATA.tech1 ,'*'&getfieldselections(Defect)&'*'),PSADATA.tech1,null())

I select the wildcard via a list, its working 100% but i what to search across

PSADATA.tech1

PSADATA.tech2

and

or PSADATA.tech3

Any ideas? Thanks Brett

Re: Wildcard Across Fields?? Is it possible.

MK_QSL — Tue, 07 Jul 2015 14:21:35 GMT

Use

GetCurrentSelections() with no parameter..

instead of GetFieldSelections()

Re: Wildcard Across Fields?? Is it possible.

Anonymous — Tue, 07 Jul 2015 14:40:32 GMT

Can you post your sample QVW file. That way we can provide you the right solution.

Re: Wildcard Across Fields?? Is it possible.

bnelson111 — Tue, 07 Jul 2015 14:53:50 GMT

Pulling all fields its a large presentation wanted to limit to

PSADATA.tech1

PSADATA.tech2

and

or PSADATA.tech3

Re: Wildcard Across Fields?? Is it possible.

bnelson111 — Tue, 07 Jul 2015 15:50:41 GMT

worked around it, con(PSADATA.tech1)&(PSADATA.tech2)&(PSADATA.tech3) as Tests

then used the wildcard.

if(wildmatch(Tests ,'*'&getfieldselections(Defect)&'*'),Tests,null())