Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to limit the list box fields ?

i have a list box with Open closed and uninstalled fields

but i need only open and closed ?

how to get this in presentation chart properties (front end) not script wise

Screenshot_5.png

thanks,

Muthu

7 Replies
vishsaggi
Champion III
Champion III

Try this? Capture.PNG

MK_QSL
MVP
MVP

Use this expression to create list box..

=IF(Match(UPPER(YourFieldName),'OPEN','CLOSED'),YourFieldName)

MarcoWedel

Hi,

another solution might be:

QlikCommunity_Thread_244810_Pic1.JPG

hope this helps

regards

Marco

Not applicable
Author

Thank you so much, Marco it is very use full for me

can we able to get this without using set analysis

MarcoWedel

Well, I think Manish Kachhia's solution might be what you're looking for.

But why would you like to avoid set analysis at all?

regards

Marco

Not applicable
Author

no i thought it would be help full for different scenarios

any way thank you

Muthu

MarcoWedel

you're welcome.

Please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco