topic Re: Insert values in a list box in QlikView

Insert values in a list box

Wed, 14 May 2014 07:16:02 GMT

Hi,

I would like to insert into a new list box selected values from the list box shown in Fig, without losing the links to these values with other values in the other list boxes. How can I do?

Thank you all in advance for the answers

greeting
Carlo

Re: Insert values in a list box

tresB — Wed, 14 May 2014 07:20:20 GMT

Could you explain a bit more?

Re: Insert values in a list box

Wed, 14 May 2014 07:53:47 GMT

Just the values I selected in the previous image that are part of the list box User Agent I would like to put them in a new box list.

Re: Insert values in a list box

tresB — Wed, 14 May 2014 07:59:20 GMT

If you are using field name [User Agent] in the list box you have shown, take another list box->Expression :

=Aggr([User Agent],[User Agent])

Is this what you want?

Re: Insert values in a list box

Wed, 14 May 2014 08:42:50 GMT

In the list box called User Agent there are many values. I would like to select only "some" values of the list box User Agent and put them in a new list box.

For example I would like to put in the new list box are the values Icc-crawler,GoogleBot-Image, AmorankSpider etc. CurlPhp, GoogleBot, etc. FeedFetcher. I would I select the values to be included in the new list box.

Re: Insert values in a list box

tresB — Wed, 14 May 2014 08:46:27 GMT

Like:

List Box->Expression =If(Match([User Agent] , 'Icc-crawler', 'GoogleBot-Image', 'AmorankSpider') ,[User Agen])

Re: Insert values in a list box

Wed, 14 May 2014 09:03:26 GMT

Adding this statement I always get the same list box. I could select the values to be included in the new list box without writing a expression?

Re: Insert values in a list box

Anonymous — Wed, 14 May 2014 15:21:15 GMT

add a new list box.

Go to the field.

Scroll down to the expression level.

Use GetFieldSelection (YourInitialField)

Hope this helps.

Antoine

Re: Insert values in a list box

Wed, 14 May 2014 16:01:27 GMT

You could duplicate the field (I used [User Agent2] for the example below) in your script and then add a 'trigger' (Settings, Document Properties, Triggers) in 'Field Event Triggers'. Find your original field, [User Agent], and then add a 'Select in Field' action under 'OnSelect':

Field: [User Agent2]

Search String: = '(' & GetFieldSelections([User Agent],'|') & ')'

Re: Insert values in a list box

Thu, 15 May 2014 08:59:41 GMT

Hi Brendan,

GetfieldSelection returns a string containing the current selections in a given field. I do not want this.

Let me explain better: I have a list box called user agent containing requests made by crawlers and users. I would like to select the crawler requests from the starting list box and place them in a new list box, deleting them from the starting list box. How could I do this?

Thank you so much for the replies.

greeting

Carlo

Re: Insert values in a list box

anbu1984 — Thu, 15 May 2014 09:05:17 GMT

Why can't you create two list boxes one with crawlers and other with users?

Do you want to create second list box only after selection?

Re: Insert values in a list box

Thu, 15 May 2014 09:12:19 GMT

Hi Antoine,

GetfieldSelection returns a string containing the current selections in a given field. I do not want this.

Doing as you say I get a list box that contains a string. Produced the new list box, I should be able to continue to selection values and deleting these values from the starting list box.

Thank you so much for the replies.

greeting

Carlo

Re: Re: Insert values in a list box

Anonymous — Thu, 15 May 2014 09:30:45 GMT

If you can flag in the code those specific values, maybe this simple example might help

Re: Insert values in a list box

Thu, 15 May 2014 10:14:06 GMT

Thanks Eruditio but I can not see the transformation because I'm using the free version of qlicview. You may postarmi the code?

thank you very much
Carlo

Re: Insert values in a list box

Anonymous — Thu, 15 May 2014 10:22:55 GMT

I'll try

I started with a simple example.

A field called Country contains Canada, UK, US and Germany (4 values)

In my example I create 2 list boxes with expressions:

1st List box with expression =if(Left(Country,1)='C',(Country))

2nd List box with expression =if(Left(Country,1)<>'C',(Country))

The result is that the first list box will only show Canada, the second list box UK, US and Germany.

All properly associated with the initial list box.

Extrapolating to your example, if you identify your users with a Flag field with 1 (or 0 for all the rest)

Then

1st List box with expression =if(Flag=1,YourField)

2nd List box with expression =if(Flag=0,YourField)

Of course, assuming I've understood what you are trying to achieve

Good luck,

Antoine

Re: Insert values in a list box

Thu, 15 May 2014 10:30:20 GMT

Hi anbu,

I would like to create the second list box by only selecting the values from the starting list box. After inserting these values in the second list box, I would like to deleting them from the starting list box.

Thanks for the reply.

Greeting

Carlo

Re: Insert values in a list box

Thu, 15 May 2014 10:36:26 GMT

Thanks Antoine now try to change according to your suggestions. I'll let you know.

thank you very much

Carlo

topic Re: Insert values ​​in a list box in QlikView

Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

Re: Insert values ​​in a list box

topic Re: Insert values in a list box in QlikView

Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box

Re: Re: Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box

Re: Insert values in a list box