Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

caniwhz1
New Contributor III

Using a part of a search result further on

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?


Suchbox.png

Thank you very much in advance for any help.

Tags (1)
9 Replies
MVP
MVP

Re: Using a part of a search result further on

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

caniwhz1
New Contributor III

Re: Using a part of a search result further on

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.

MVP
MVP

Re: Using a part of a search result further on

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

rahulpawarb
Valued Contributor II

Re: Using a part of a search result further on

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

caniwhz1
New Contributor III

Re: Using a part of a search result further on

Thats possible.

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

That's the problem.

Suchbox 2.png

caniwhz1
New Contributor III

Re: Using a part of a search result further on

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

Highlighted
MVP
MVP

Re: Using a part of a search result further on

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)

caniwhz1
New Contributor III

Re: Using a part of a search result further on

Hello Rahul,

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

Have a nice day.

Reagards.
Cathleen

caniwhz1
New Contributor III

Re: Using a part of a search result further on

Hello Tresescol,

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

Have a nice day.

Reagards.

Cathleen

Community Browser