Advanced Search

[adamjwchen]

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.

[OmarBenSalem]

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?

[Anonymous]

I think he means something like

Listbox FieldA:

=rank(sum(FieldB))<=4

[OmarBenSalem]

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

[adamjwchen]

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.

[Anonymous]

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

[adamjwchen]

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]

Ah ok, that's also possible :

This is how you do it :

1)

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

3) Once finished, Click Ok:

[OmarBenSalem]

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 :

to :

[adamjwchen]

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