Search in QlikView

[Anonymous]

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

[vinieme12]

add an expression listbox

example

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

[Anonymous]

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.

[Peter_Cammaert]

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.

[micheledenardi]

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

[Anonymous]

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?

[Anonymous]

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.

[Anonymous]

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.

[micheledenardi]

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.

[vinieme12]

"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

V