List box advance serch

[poonam_kulwal]

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

[rahulpawarb]

Please refer below link:

Advanced Search dialog ‒ QlikView

Regards!

Rahul

[avinashelite]

Check this

Searching in listboxes of numerics | Qlik Community

[Anil_Babu_Samineni]

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

[poonam_kulwal]

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.

[Anil_Babu_Samineni]

Change it to Use Normal Search from General tab

[Anonymous]

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.

[ganeshsvm]

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

[poonam_kulwal]

Thank you all for your support.

Regards,

Poonam

[Anil_Babu_Samineni]

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