topic Re: Searchable Expression in QlikView

Searchable Expression

mphekin12 — Tue, 07 May 2013 13:33:13 GMT

Hello,

I have the following expression in a Straigh Table:

=if(PPV.ProductID=ProductID, 1
     ,if(PPV.ProductID=PU.ProductID, 1
          ,if(PPV.ProductID=PQ.ProductID, 1
               , 'No Match'
          )
     )
)

I am trying to make it searchable so I can see all non-matches. When click the 'Search' icon and type *No Match* nothing happens. Did anyone else ever experience this issue? Can anyone offer any advice on how to perform this search correctly?

Thanks!

Re: Searchable Expression

Tue, 07 May 2013 14:16:20 GMT

i'd say use applymap function in your load script, then it will definitely be searchachle.

Re: Searchable Expression

mphekin12 — Tue, 07 May 2013 14:25:34 GMT

nicksatch,

Thanks for the suggestion, but the applymap function will not work for me in this instance.

Does anyone else have any other suggestions?

Thank you!