topic Re: List box advance serch in QlikView

List box advance serch

poonam_kulwal — Wed, 25 Nov 2020 16:16:04 GMT

HI All,

I have a list box with file size in Byte only,

For Example:-

23453425bytes,

324543bytes

212bytes

790bytes

23452566663bytes

324534bytes

Now my client want search functionality for this list box with operators >, <, >=, <=

If user want to see information for file which are >, <, >=, <=certain size.

I was going through Qlikview help.

ListBox Property -> Default Search Mode ->

I am not able to see Numeric search as an option.

Could you guide me on how to achieve this requirement.

Thanks,

Poonam

Re: List box advance serch

rahulpawarb — Fri, 28 Apr 2017 04:12:57 GMT

Please refer below link:

Advanced Search dialog ‒ QlikView

Regards!

Rahul

Re: List box advance serch

avinashelite — Fri, 28 Apr 2017 04:18:52 GMT

Check this

Searching in listboxes of numerics | Qlik Community

Re: List box advance serch

Anil_Babu_Samineni — Fri, 28 Apr 2017 05:03:44 GMT

I doubt, Whether this will work or not due to you have numeric and String on your field. So, this is the case i am thinking first do purgechar for field then try to concat with the field of bytes string. It could be easier. Or best option make one more search object then pause that condition on search from presentation tab. We can say work around

hic‌ will provide more information

Re: List box advance serch

poonam_kulwal — Fri, 28 Apr 2017 05:29:49 GMT

Hi Anil,

I have only numbers in that column.

I am looking for in listbox search if I type >4000 then it should display me filesize with more than 4000 only.

Thanks.

Re: List box advance serch

Anil_Babu_Samineni — Fri, 28 Apr 2017 05:36:29 GMT

Change it to Use Normal Search from General tab

Re: List box advance serch

Anonymous — Fri, 28 Apr 2017 06:15:46 GMT

Qlikview list boxes by default works that way. !! IF you click on search and type >4000, the liast box only displays values >4000. If the field is numeric.

Re: List box advance serch

ganeshsvm — Fri, 28 Apr 2017 06:16:45 GMT

Hi,

Basically QlikView provides the power feature to search for different numeric criteria as required in your case and you don't need to do any specific setting for numeric search in list box.

And also Avinash R has provided with a proper link detailing about different search criteria.

Find the below image for your reference.

Regards,

Ganesh

Re: List box advance serch

poonam_kulwal — Fri, 28 Apr 2017 18:52:04 GMT

Thank you all for your support.

Regards,

Poonam

Re: List box advance serch

Anil_Babu_Samineni — Fri, 28 Apr 2017 18:54:36 GMT

If you happy with the answer, You can mark the helpful and then please close the thread by flag Correct Answer