topic Search in QlikView in QlikView

Search in QlikView

Anonymous — Fri, 25 Aug 2017 14:55:40 GMT

Hi all,

Traditionally it is possible to define search in a certain field. But I need to tune it somehow.

Imagine that my field "Ads" consists of more than 5 thousands values.

There's another field "Year of Ads issue". It means that I can define, for example, 2017 in order to limit the list of ads to 2017 only.

My task is the following:

I want to allow my users to search in the field "Ads" BUT limited to ads issued in 2017.
In search results there should be only ads issued in 2017.

Is ti possible?

Thank you in advance,

Larisa

Re: Search in QlikView

vinieme12 — Fri, 25 Aug 2017 15:01:22 GMT

add an expression listbox

example

= AGGR(only({< Year= {2017} >} Ads) , Ads)

Re: Search in QlikView

Anonymous — Fri, 25 Aug 2017 15:17:01 GMT

The question is not about a list box. It is about a search object.

The point is that the list of values is huge (about several thousands). There's no point to display them all in a list-box. Search funstion would be much more convenient.

I need to set a condition for a Seach object: search within "Ads" but limited to "Year" = 2017.

Re: Search in QlikView

Peter_Cammaert — Fri, 25 Aug 2017 15:29:37 GMT

QlikView has a simple standard Search option to do just that.

Create a listbox displaying Ads (ok, there are many values but that's just fine for now)
Open the search field for this listbox (click the magnifier or type a space)
On the far right, you'll see a >> (chevron). Click that one. The search field expands with a secondary search area.
Type value 2017 in the search field (you should have the ad years available as separate values for this simple example to work) and select the proper value/field combination (probably a "Year" field) from the secondary search list.
You have now temporarily reduced the search coverage to ads from 2017.
Now search whatever Ad name or string you want from the resulting list by entering a value in the primary search field..

Best,

Peter

[Edit] ? icon means help. Magnifier opens search field.

Re: Search in QlikView

micheledenardi — Fri, 25 Aug 2017 15:49:24 GMT

The only way to do this is to create a new field via script that contains only 2017 ads.

Re: Search in QlikView

Anonymous — Fri, 25 Aug 2017 15:51:09 GMT

Hi Peter,

Unfortunately, the icon in the right-upper corner of a list-box doesn't allow to show search results in a convenient way. I would not use it. I think that a Search Object is much more user-friendly.

My clients are used to seeing the search results displayed by a Search Object in the way you can see on the screenshot (see the attachment). This sort of search results display is only possible if a Search Object is used.

As the list of values in the search results is huge, my clients ask me to be able to limit the search results to a certain year.

If no standard tool can be applied, is it possible to tune a Search Object by means of an extension?

Re: Search in QlikView

Anonymous — Fri, 25 Aug 2017 15:52:22 GMT

I would suggest you to create a new field in the load script on the same table that has your ads:

If(Year=2017, Ads) as Ads2017

It will contain only ADS of current year, you can then use the search function on that field.

Re: Search in QlikView

Anonymous — Fri, 25 Aug 2017 15:55:40 GMT

All search engines allow to limit search results according to the required conditions.

I wouldn't call it smart to create in QlikView separate fields for this task.

Re: Search in QlikView

micheledenardi — Fri, 25 Aug 2017 16:07:14 GMT

I'm sorry but i know how QlikView works and there are no possibility to do what you want except to create a new field or use a ListBox.

If you can't accept these solutions the only way is to create a new customized extension.

Re: Search in QlikView

vinieme12 — Sat, 26 Aug 2017 07:16:16 GMT

"All search engines allow to limit search results according to the required conditions."

Hi, can you please suggest some? i'm keen to know

I wouldn't call it smart to create in QlikView separate fields for this task.

This is your best option for a searchbox

Thanks

Re: Search in QlikView

Anonymous — Sun, 27 Aug 2017 11:43:03 GMT

Yes, I can give an example.

Think about online ticketing, I mean all the web-sites providing the service of buying tickets online.

1) You select a city of destination.

2) Then you select the date of departure and arrival.

3) Finally you click "Find".

In search results you see the flights corrresponding to your conditions.

I need a similar logic of search in my QlikSense app.

Are there any ideas how I can do it?

Thank you in advance.

Re: Search in QlikView

MarcoWedel — Sun, 27 Aug 2017 21:45:51 GMT

Hi,

maybe you could deselect the "include excluded" option in the search object properties and limit the years before searching for Ads:

hope this helps

regards

Marco