Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
mohan_1105
Partner - Creator III
Partner - Creator III

How to match the expression with a table?

Hi,

I have three column which is created by if condition which ranges from 1 to 5. And the fourth column, which is a concatenate of three column and it is my Qlik output by expression. The table looks similar to the following image,

Capture.JPG

I have an another excel file, which is the dictionary of PQM column and it looks like,

Capure.JPG

Now, how can I match the PQM column which is generated by expression in Qlik and match the generated PQM column with the table PQM column and get the name inside Qlik. My final output in Qlik should be like,

Care.JPG

12 Replies
sunny_talwar

Would you be able to share a sample to show the issue?

mohan_1105
Partner - Creator III
Partner - Creator III
Author

Thank you Sunny, It is working good with the sample data. I think there is an issue with my own data.

sunny_talwar

Oh okay.... got it