topic Re: Limit search object results by set analyzes in QlikView

Limit search object results by set analyzes

ladislav — Mon, 30 Mar 2015 14:00:37 GMT

Hi,

I have couple of different data sources in my model. Financial, Sales, Product. They all use a bit different country names.
I have only one 'CountryName' field and therefore those results mix up. When I use search object I get 3 results for single search string.
I can easily resolve it using set analyzes, (limiting data source) in other objects but there is no way to use set analyzes for search object fields, is it?

Thanks

Re: Limit search object results by set analyzes

marcus_sommer — Wed, 01 Apr 2015 07:35:10 GMT

For this you could use mapping - see here an example from HELP:

Mapping1:

MAPPING LOAD * INLINE [
x,y
US,USA
U.S.,USA
America,USA
Amerika,USA];

Map1:
mapping load * inline [
x,y
1,eins
2,zwei
3, drei ] ;

ApplyMap ( 'Map1', 2 )	liefert	zwei
ApplyMap ( 'Map1', 4 )	liefert	4

- Marcus

Re: Limit search object results by set analyzes

pokassov — Wed, 01 Apr 2015 07:47:31 GMT

I agree with Marcus.

If the same data in different data sources have different writing then someone have to rearrange data.

Re: Limit search object results by set analyzes

ladislav — Wed, 01 Apr 2015 07:59:37 GMT

Marcus thanks for your reply.

I think your advise means fixing different country naming’s on the source and than using this new field in search object. But that doesn’t solve my issue.

That is because these differences are relevant for each department/data source.

I have 3 different data sources and 3 different set of reports in one model. Depending on the particular report I need to search for data only in the relevant data source to get correct searcg results. That is why I was wondering if I can use set analyzes on fields in search object somehow.

This is not a problem of just a Country_Name field. There are other fields shared across the model.

I have one facttable where data from all sources are alltogether. Data sources in this facttable are differentiated/recognized by FACTYPE_ID= A, B or C.

Re: Limit search object results by set analyzes

ladislav — Wed, 01 Apr 2015 08:19:55 GMT

Hey pokassov,
thanks for yor reply but that is not the solution I need. Could you please check my response to Marcus?

Thanks, I appreciate.

Re: Limit search object results by set analyzes

pokassov — Wed, 01 Apr 2015 08:22:08 GMT

May be you can use different states and lock FactType?

Then you can't choose wrong country.

Of cause you have to use set analysis to choose selected countries in state.

Sergey.

Re: Limit search object results by set analyzes

marcus_sommer — Wed, 01 Apr 2015 08:27:56 GMT

If you a field for the datasource like FACTYPE_ID used in your datamodel you could use this as filter in set analysis expressions. If you really need different fields for the same kind of information you could use an approach like translating different languages - How to Handle Multi-Language Translations in QlikView.zip - or you used these different fields only within the special sheets maybe matcht per a variable over getactivesheetid(). Then your fields will be fit to each sheet and if an user searched in this fields they will only see these data - by using a searchbox you will need to restrict the fields - eventually you could also use alternate states.

- Marcus

Re: Limit search object results by set analyzes

ladislav — Wed, 01 Apr 2015 09:12:08 GMT

I like the idea with alternate states, as I already use them for each report but even when I lock the FACTYPE_ID the search results give me Country also for other FACTYPEs even though they don't apply when selected.

Of course I have same state on all objects. See below. There is no Austria in MS FACTTYPE_ID. But there is search result for it.

Is there a way to make set analyzes in search object? For example in list of fields? So there will be no search results for Austria in this sheet which has FACTTYPE_ID=MS?

Thanks

Re: Limit search object results by set analyzes

ladislav — Wed, 01 Apr 2015 09:16:01 GMT

"by using a searchbox you will need to restrict the fields - eventually you could also use alternate states."

That is what I am looking for. I have one field and more data sources in it. I know set analyzes syntax but I don't know how to use it in search object. What would be the syntax here?

Thanks

Re: Limit search object results by set analyzes

marcus_sommer — Wed, 01 Apr 2015 09:20:50 GMT

Have a look on the option "search in excluded values" in tab presentations. If this don't work I think you will need a specialized search-object on each sheet and using these different fields for the search.

- Marcus

Re: Limit search object results by set analyzes

stigchel — Wed, 01 Apr 2015 09:26:24 GMT

You can maybe build a custom 'search box', it is a work around and does not completely work as a search box, but...

Add an input box where the user can enter the search string in a variable e.g. vSearch. Then make a listbox where you use an expression like

Aggr(Only({<FACTYPE_ID='A', MySearchField={'*$(vSearch)*'} MySearchField),MySearchField)

Re: Limit search object results by set analyzes

ladislav — Wed, 01 Apr 2015 09:27:25 GMT

Perfect that helped. When FACTTYPE_ID is locked and I uncheck 'include excluded' the search results are clear.

Thanks a lot Marcus!

Re: Limit search object results by set analyzes

ladislav — Wed, 01 Apr 2015 09:28:58 GMT

Thank you Sergey!

Re: Limit search object results by set analyzes

ladislav — Wed, 01 Apr 2015 09:30:33 GMT

Good Idea too.

Thanks