topic Re: Seleccionar varios campos excepto uno in QlikView

Select multiple fields except one / Seleccionar varios campos excepto uno

daniel1017 — Fri, 20 Nov 2020 18:02:30 GMT

Such a good day,

Sorry, I'm new to the platform and I wonder if I can count on your support, my problem is this:

I have a book in Excel with a column that contains several lines of transportation (more than 100), I would like to know a method by which puada generate a button with the action filter and select all lines except one. I understand that can be performed by the method "string" but eventually they will agegar more lines and the only thing I want is for the other lines without which specific display, made it clear they do not want to delete records from this line.

I hope I have explained and await your response.

Thank you so much!

- - - -

Que tal buen día,

Disculpen, soy nuevo con la plataforma y quisiera saber si puedo contar con su apoyo, mi problema es el siguiente:

Tengo un libro en Excel con una columna que contiene varias lineas de transporte (mas de 100), quisiera saber un método por el cual puada generar un botón con la acción de filtrar y seleccionar todas las lineas excepto una. Entiendo que se puede realizar por el metodo "Cadena de Texto" pero con el tiempo se van agegar mas lineas y lo unico que quiero es que se muestren las demas lineas sin la que especifico, dejo en claro que no quiero eliminar los registros de esta linea.

Espero me haya explicado y espero su respuesta.

Muchas Gracias!

Note: Edited by moderator to include English translation as a courtesy

Re: Seleccionar varios campos excepto uno

Marcio_Campestrini — Fri, 18 Dec 2015 12:33:42 GMT

Daniel,

A solution for you is to show your user to select to value he don't want to see, click with the right button at the list box and then select the option "Select excluded". After this he can create a bookmark with this filter.

Hope this help you.

Re: Seleccionar varios campos excepto uno

daniel1017 — Fri, 18 Dec 2015 14:14:46 GMT

Thanks a lot for the answer Marco, I thought that, but is there a way i could transform the bookmark into an action button?

Thanks for you help!

Re: Seleccionar varios campos excepto uno

Marcio_Campestrini — Fri, 18 Dec 2015 18:41:30 GMT

Daniel

You can create a button (or a text object) and define an action: Action Type: Bookmark / Action: Apply Bookmark, and you put the ID of the bookmark that you created.

The BookmarkID you verify acessing Bookmarks/More, and look the bookmark you created.

Re: Select multiple fields except one / Seleccionar varios campos excepto uno

effinty2112 — Sun, 20 Dec 2015 15:54:37 GMT

Hi Daniel,

If each row can be identified by a field 'TransportationID' then if you select on that field first you can select all excluded using a button with the action shown below.

Re: Select multiple fields except one / Seleccionar varios campos excepto uno

daniel1017 — Mon, 21 Dec 2015 14:33:03 GMT

Thanks so much Andrew it works a lot for me your answer, great help!

Re: Seleccionar varios campos excepto uno

daniel1017 — Mon, 21 Dec 2015 14:33:56 GMT

Thanks Marco,

Now i know how to create that action buttons, thanks alot fo the help.

Have a nice day!

Re: Select multiple fields except one / Seleccionar varios campos excepto uno

Marcio_Campestrini — Tue, 17 May 2016 13:10:31 GMT

Hi Daniel

Is your problem solved? If yes, please mark helpful/correct questions to close the thread.

Thanks.

Re: Select multiple fields except one / Seleccionar varios campos excepto uno

Marcio_Campestrini — Mon, 31 Oct 2016 18:55:19 GMT

Have you solved your problem? If you did, please choose the correct answer and help us to keep community focused.

Re: Select multiple fields except one / Seleccionar varios campos excepto uno

Marcio_Campestrini — Mon, 29 May 2017 14:12:23 GMT

Got you issue solved? Please mark helpful/correct answers.