topic How to remove values from a list box in QlikView

How to remove values from a list box

Fri, 09 May 2014 14:34:53 GMT

Hi,

I have a list box called Requests. In this list box, there are values that I want to delete to exclude them from the analysis. I enclose a picture that shows the values that I want to delete. How can I do?

thank you very much
Carlo

Re: How to remove values from a list box

alexandros17 — Fri, 09 May 2014 14:45:30 GMT

Nella listbox, nella finestra "Campo" seleziona la voce "Espressione" e scrivi:

If(IsNum(MyField), MyField, Null())

Ovviamente cambia MyField con il tuo campo

Fammi sapere

Re: How to remove values from a list box

sudeepkm — Fri, 09 May 2014 14:46:08 GMT

if you want to remove those values from Data Model then use where clause in your load script.

If you just want to remove them from the List Box then use an expression in the List Box instead of the Field name itself.

Re: How to remove values from a list box

Fri, 09 May 2014 15:35:10 GMT

Alessandro ho provato la tua espressione ma viene cancellato completamente il contenuto della casella di testo . Ti ringrazio comunque per la risposta. Non c'è un altro modo? non posso selezionare direttamente i valori che voglio cancellare?

Re: How to remove values from a list box

alexandros17 — Fri, 09 May 2014 15:45:38 GMT

Ciao Carlo,

nell'esempio mostri una serie di valori da escludere (in verde) ma i valori giusti quali sono ?

Io pensavo fossero numeri (infatti ho utilizzato IsNum()),

Dammi un esempio dei valori da includere in modo da elaborare una logica di visualizzazione

Ciao

Re: How to remove values from a list box

Jason_Michaelides — Fri, 09 May 2014 16:02:41 GMT

I don't understand Alessandro's responses so I'm not sure if this has been answered already...

You could consider bookmarking the selection of the excluded values, then use Set Analysis to reference that bookmark and exclude it:

Sum({-BM01} Sales)

Hope this helps,

Jason

Re: How to remove values from a list box

Sat, 10 May 2014 10:31:45 GMT

Hi Jason,

Thank you for the advice. It 'a good starting point. Thanks to your response I select values from eslcudere from my analysis. In any case I'll try to make an expression that I can solve the problem.

thank you very much

Carlo

topic How to remove values ​​from a list box in QlikView

How to remove values ​​from a list box

Re: How to remove values ​​from a list box

Re: How to remove values ​​from a list box

Re: How to remove values ​​from a list box

Re: How to remove values ​​from a list box

Re: How to remove values ​​from a list box

Re: How to remove values ​​from a list box

topic How to remove values from a list box in QlikView

How to remove values from a list box

Re: How to remove values from a list box

Re: How to remove values from a list box

Re: How to remove values from a list box

Re: How to remove values from a list box

Re: How to remove values from a list box

Re: How to remove values from a list box