topic Re: Using a part of a search result further on in QlikView

Using a part of a search result further on

caniwhz1 — Tue, 07 Feb 2017 08:53:23 GMT

Hallo,

I hope that I'm in the right forum with my question:

Is it possible to transfer a part of the search result (XXXXX) into another search box?

In Excel, for example, I would use the Formel „=left(column_line/;5)“. Is there any possibility in Qlik View?

Thank you very much in advance for any help.

Re: Using a part of a search result further on

tresB — Tue, 07 Feb 2017 09:02:01 GMT

Could you please explain a bit more with a sample case may be?

Re: Using a part of a search result further on

caniwhz1 — Tue, 07 Feb 2017 09:08:18 GMT

I have two independent search boxes.

I start with the search in search box 1 and get in the multibox a result (rnr_afo: XXXXX_YY).

Now I need the XXXXX result (in mulitbox 1) for another searching in searchbox 2.

I must search with XXXXXX in another column.

Re: Using a part of a search result further on

tresB — Tue, 07 Feb 2017 09:15:31 GMT

Try typing like: =Left(rnr_afo,5) in your second search box.

Re: Using a part of a search result further on

rahulpawarb — Tue, 07 Feb 2017 09:29:13 GMT

Hello Cathleen,

Trust that you are doing well!

To tackle such situation you can make use of addition field in script. For example, if you have search box 1 using ColumnLine1 field then create another field in script as LEFT(ColumnLine1,5) As NewColumnLine1 and use it in search box 2.

I hope this will be of help.

Regards!

Rahul

Re: Using a part of a search result further on

caniwhz1 — Tue, 07 Feb 2017 09:32:15 GMT

Thats possible.

But the formula must reference the search result in the multibox, not the column.

That's the problem.

Re: Using a part of a search result further on

caniwhz1 — Tue, 07 Feb 2017 09:42:05 GMT

Hello Rahul,

I know it is a little bit confuse.

I need no new column. What I want is, that the left part of the search result (written in the multibox) will be automaticly transfer in the next search box for further searching.

Regards!

Cathleen

Re: Using a part of a search result further on

tresB — Tue, 07 Feb 2017 09:47:20 GMT

You can't refer a search result that way. However, you perhaps can somewhat try putting your first search criteria (instead of the field itself) within the second one like:

=Left( <First Search String/Expression>,5)

Re: Using a part of a search result further on

caniwhz1 — Tue, 07 Feb 2017 09:59:05 GMT

Hello Rahul,

Thank you.
I have combinate some answer parts. Now it works.

Have a nice day.

Reagards.
Cathleen

Re: Using a part of a search result further on

caniwhz1 — Tue, 07 Feb 2017 09:59:38 GMT

Hello Tresescol,

Thank you.
I have combinate some answer parts. Now it works.

Have a nice day.

Reagards.

Cathleen