topic Re: Return a special field in a text box in App Development

Return a special field in a text box

HAMID_AKBARI — Sun, 08 Jun 2025 08:55:44 GMT

I have a table of Equipments and a table of their technical specifications.

every row of specification table has two column :a specification title and specification value.

e.g Manufacturer ---- PHILIPS

date of Manufacture ---- 2005

I want to show a special record in a text box that represent e.g manufacturer of equipments when an Equipment select.

Since the records are not same in specification might be diffrent in words e.g "manufacturer" or "manufacture by" or "made by"...

so the solution should regar search with like..

Thanks in advance.

Re: Return a special field in a text box

Vegar — Sun, 08 Jun 2025 17:10:28 GMT

I found it hard to get a grip on how your data look like. Is the examples above two rows and two columns, or two rows but one column?

It would help a lot if you could showcase a small sample of your data, including rows with "manufacturer" or "manufacture by" or "made by". Please also explain how the output you would be based on your sample data set.

Re: Return a special field in a text box

HAMID_AKBARI — Mon, 09 Jun 2025 10:31:07 GMT

it was solved by Rubmarin in Other post

=Only({<SP_DESCRIPTION={"*Manufact*"}>-<SP_DESCRIPTION={"*Date*"}>} SP_VALUE)

Thanks by the way

Re: Return a special field in a text box

Vegar — Mon, 09 Jun 2025 11:08:05 GMT

Thanks for updating this thread as well with the solution.

I assume it is this response by @rubenmarin that you are referring to: https://community.qlik.com/t5/App-Development/Return-a-field-from-one-column-by-other-column-name-like/m-p/2520499/highlight/true#M106429