Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?
I think he means something like
Listbox FieldA:
=rank(sum(FieldB))<=4
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
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.
I think this is called compound search.... I talked about expression 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.
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:
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 :
I don't get it. The expression string has length limit.