How to filter a list box and data

[#1]

Hi,

i would like to know if is it possible to filter a list on only one sheet.

ie.

I have a table with 10 users.

User1... User10

On the sheet 1, i want to see only user1... user5 on the list box, on the charts (facts).

On the sheet 2, i want to see only user6... user10 on the list box, on the charts (facts).

Tell me, if you want more details.

Thk.

Jérôme.

[swarup_malli]

Jerome,

It is possible, create a new listbox(right click + new sheet object + listbox),on the properties choose expressions, then u can add an expression to filter the users.

Regards

Swarup

[#3]

Hi Swarup,

Some example please ?

I tried if (uti='user1',1,0) but no filter

thks

Jérôme

[#4 · Accepted solution]

hi

I found here

http://community.qlik.com/thread/8383

The filter must be done on the field on the general tab.

Thks Swarup