topic Re: List box in QlikView

List box

mario-sarkis — Wed, 25 Nov 2020 16:16:04 GMT

‌hey all

i have a list box containt field name but in this field i have a "-" but i dont want to show it

how can i show all the name of this list box except this "-"?

i Dont want to change the field in the script coz my use it for other calculation in the dashboard.

thanks

sunny_talwar — Mon, 21 Mar 2016 12:23:22 GMT

May be this as your list box expression:

If(FieldName <> '-', FieldName)

mario-sarkis — Mon, 21 Mar 2016 12:26:17 GMT

‌hi sunny no it didn't work it show another same column

sunny_talwar — Mon, 21 Mar 2016 12:28:44 GMT

Can you show a screenshot of what you are seeing?

ali_hijazi — Mon, 21 Mar 2016 12:34:33 GMT

scroll down to expression where you can put if(your_field <> '-', your_field)

mario-sarkis — Mon, 21 Mar 2016 12:38:35 GMT

‌thank you ali, i thought sunny is telling have to do it in the expression tab not the drop down list

sunny_talwar — Mon, 21 Mar 2016 12:40:22 GMT

Is it working now? If it is, I would request you to close this thread by marking the correct answer.

Best,

Sunny