Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
bimala0507
Partner - Creator
Partner - Creator

Can List Box display lists be controlled

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

14 Replies
alexandros17
Partner - Champion III
Partner - Champion III

At the end of list of fields there is an item "Expression", write there the condition to show items, ex.: If(myCond, myField, Null())

let me know

tresesco
MVP
MVP

Expression like:

If(Field='Value1' or Field= 'Value2', Field)

Or,

If(Match(Field,'Value1' , 'Value2'), Field)

bimala0507
Partner - Creator
Partner - Creator
Author

Hi:

I tried that. It just shows the expression value as null() against the item, but I want the list item should be excluded if the condition satisfies.

Kind Regards,

Bimala

tresesco
MVP
MVP

Just an extra Not would do the job. Try like:

If( Not myCond, myField)

bimala0507
Partner - Creator
Partner - Creator
Author

Hi:

Appreciate, if an example can be given.

Kind Regards,

Bimala

arulsettu
Master III
Master III

try this in list box expression

field - your field

if(match(field,'1','2','3','4','5'),field)

tresesco
MVP
MVP

I am in hunt of appreciations. . PFA

bimala0507
Partner - Creator
Partner - Creator
Author

Hi Tresesco:

Thank you so much for your assistance. But my requirement is little different. I want to control the display of field1, by checking the field2 .

E.g. field1 field 2

        'xxxx'    1

        'yyyy'      1

        'zzzz'      0

I would like to give a condition that if (field2=1) , than display all those field1 which satisfies the condition.

Attached the qvw file for your reference.

Kind Regards,

Bimala

anbu1984
Master III
Master III

Try this expression

=If([field2]=1,field1)