topic Re: Filter in Listbox in QlikView

Filter in Listbox

n1ef5ng1 — Thu, 04 Jul 2013 07:13:19 GMT

Hi guys,

I have a listbox that contain hundreds of service code,

However in this particular report, I only want the user to choose 20 service code.

It will not be user friendly for the user to select the hundreds of service code when there is only 20 service code that are valid

Therefore my qn is whether is there any way i can filter the listbox?

Thanks

Re: Filter in Listbox

Sokkorn — Thu, 04 Jul 2013 07:16:46 GMT

Hi,

The answer is "Yes for Sure". We can limit item in list box. Here is some clue by using expression, something like =Aggr(Only({1<Field = {1,2,3}>} Field) Field)

If you have some sample data that quite easy to figure out.

Regards,

Sokkorn

Re: Filter in Listbox

Anonymous — Thu, 04 Jul 2013 07:20:27 GMT

Check listbox expresion. go through attach file

Re: Filter in Listbox

Sokkorn — Thu, 04 Jul 2013 07:20:42 GMT

See sample

[Data]:

LOAD * Inline [

Cliente

4];

Create a list box with expression =Aggr(Only({1<Cliente = {1,2}>} Cliente),Cliente) -> will see only 1 and 2

Regards,

Sokkorn