Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
mohan_1105
Contributor 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

1 Solution

Accepted Solutions

Re: How to match the expression with a table?

I think an aggregation function might be needed, but difficult to say in details

Aggr(If(PQMField = PQMExpression, Name), ChartDimensions, PQMField)

12 Replies
OmarBenSalem
Esteemed Contributor

Re: How to match the expression with a table?

How is Name Associated with PQM 111,112 in excel and PQM 141 in your generated expression in the same time?

What's the relation btwn 111,112 and 141?

mohan_1105
Contributor III

Re: How to match the expression with a table?

Hi,

There is no relationship btw 111, 121 and 141... those were generated from expression.

I have a dictionary for that generated numbers in a separate excel sheet, I need to add the Name of the specific number in Qlik sense by matching the PQM number with generated PQM number.

Thanks

OmarBenSalem
Esteemed Contributor

Re: How to match the expression with a table?

How and where have you created P , Q and M?

In the script? In an external file or directly within the table?

mohan_1105
Contributor III

Re: How to match the expression with a table?

I created the P, Q, and M in the table. It is created by if condition having 1 to 5 scale.

beck_bakytbek
Honored Contributor

Re: How to match the expression with a table?

Hi Mohan,

try this: Match the values from a list in different table.

i hope that helps

beck

mohan_1105
Contributor III

Re: How to match the expression with a table?

Hello Bech,

In your suggestion, both the table are in the backend, so using mapping function we can do that.

In my case, I have a table in the frontend and dictionary table in the backend. So, here how can I use map function.

OmarBenSalem
Esteemed Contributor

Re: How to match the expression with a table?

stalwar1‌, can you help with this? Thanks

Re: How to match the expression with a table?

I think an aggregation function might be needed, but difficult to say in details

Aggr(If(PQMField = PQMExpression, Name), ChartDimensions, PQMField)

mohan_1105
Contributor III

Re: How to match the expression with a table?

I understood, how this script worked

But still, there is a mismatch !!

Pleasure !!