Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
adamjwchen
New Contributor III

Advanced Search

Hi,

Is there any way to perform Advanced Search in Sense? like the Advanced Search function in QV? I can give a list to filter out the data.

14 Replies
OmarBenSalem
Esteemed Contributor

Re: Advanced Search

What do mean exactly by advanced search? Can you provide an example of what you were doing with QlikView and want to implement in Qlik Sense? To see if I could help you to accomplish this?

roharoha
Valued Contributor III

Re: Advanced Search

I think he means something like

Listbox FieldA:

=rank(sum(FieldB))<=4

OmarBenSalem
Esteemed Contributor

Re: Advanced Search

Ah ok; well yes, in that case, that exists :

Please refer to this :

https://help.qlik.com/en-US/sense/3.2/Subsystems/Hub/Content/Search/data-search.htm

Example, I want to select the Plane that are over 50% loaded with passenegers:

my research would be :

=(sum(Remplissage)/sum([Capacité]))>0.5

Capture.PNG

adamjwchen
New Contributor III

Re: Advanced Search

what I need is something like the attached screenshot, to use search expression to give a long list and by hitting Go button to select all data.

The search filed in Sense has limited length which cannot support super long list.

roharoha
Valued Contributor III

Re: Advanced Search

I think this is called compound search.... I talked about expression search

adamjwchen
New Contributor III

Re: Advanced Search

My problem is the text bar of the search function can only allow about 255 characters at once. when I have a long long list, it cannot be done at once like what I did in QV.

OmarBenSalem
Esteemed Contributor

Re: Advanced Search

Ah ok, that's also possible :

This is how you do it :

1)

Capture.PNG

2) Enter what you want to search here  (ur list) :

Capture.PNG

3) Once finished, Click Ok:

Capture.PNG

OmarBenSalem
Esteemed Contributor

Re: Advanced Search

As I said and showed you, you can search by expression in a specific List Box, but to enter a list , you'll have to enter it in the global search component as mentionned above

But, with that being said, you can always make any object in your sheet go full screen:

from :

Capture.PNG

to :

Capture.PNG

adamjwchen
New Contributor III

Re: Advanced Search

I don't get it. The expression string has length limit.