Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
HAMID_AKBARI
Contributor III
Contributor III

Return a field from one column by other column name like somthing

Hi Community

i have database of diffrent Equipments and their Technical Specifications.

Unfortunately the data Specification Entities are not equal by name eg

sometimes maker company Entered "manufacturer" and sometime "Manufactured By"

The DB structure sample is attached 

Now the Problem:

I want to create a panel that user select an Equipment and the the spec value shown in text box.

Infact need a script that Return "SP_Value" that "SP_Description" Like "Manufact" for text box one and

Return "SP_Value" that "SP_Description" Like "Date" for textbox two and .....

Labels (2)
1 Solution

Accepted Solutions
rubenmarin1

Hi, the expression could be:

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

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

But I think it would be easier if you solve it in script, apply a mapping so it converts all differnt values to the same, also you can convert the date values to something that doesn't have the 'Manufact' word in it.

View solution in original post

2 Replies
rubenmarin1

Hi, the expression could be:

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

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

But I think it would be easier if you solve it in script, apply a mapping so it converts all differnt values to the same, also you can convert the date values to something that doesn't have the 'Manufact' word in it.

HAMID_AKBARI
Contributor III
Contributor III
Author

Thats it.Very nice.Thank you