Re: Can List Box display lists be controlled - Page 2 - Qlik Community

bimala0507 · ‎2015-02-09

Dear experts:

Is there a way, I can control the list of values in list box.

E.g: I have a list of Item1.... Item10 values against a dimension and based on certain condition I would like to show only 5. Can it be achievable ?

Kind Regards,

Bimala

PrashantSangle · ‎2015-02-09

Hi,

Use

Aggr(Field2,field1)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

bimala0507 · ‎2015-02-09

Hi:

I tried the aggregate functions , but not getting the required result.

Kind Regards,

Bimala

anbu1984 · ‎2015-02-09

Check this

=If([field 2]=1,field1)

bimala0507 · ‎2015-02-10

Hi:

I checked, it is working fine. But in my case it just greys out, the values and still shows. Is it because I am using Cross Table. Appreciate, if you can check my app attached and replicate the same. I want to show only those dimensions which has Show_flag as 1 and hide rest for each report selected. Appreciate a quick help.

Kind Regards,

Bimala

anbu1984 · ‎2015-02-10

I am using PE. I did binary load of your data and created List box. Check the settings of list box in attached app with yours. You can also copy this list box and paste in your app