How to compare a pivot metric value in another column of different table and pickup the additional column jut like VLOOKUP

Wed, 20 Apr 2016 07:57:40 GMT

Hi,

In our Qlik dashboard we have a pivot table where we have some dimensions and 5 metrics. We are creating a new metric by concatenating existing 5 metrics. The new metric is of string type (even though they look like numbers but they have spaces in between). In below screen shot we have added a column "Pivot Code". Wherever in any of the metric value is not available we are replacing it with single space as you could see in Pivot Code column values.

Now we have another table which has 3 columns. refer 2nd screen shot.

What we need is to create a new column in Pivot (1st screen) by comparing the "Pivot Code" and "Code" columns and get the "Trending Towards".

We have already tried following

using Match function, Pick function, Only function. We tried to convert this in Integer also but nothing worked.

topic How to compare a pivot metric value in another column of different table and pickup the additional column jut like VLOOKUP in QlikView

How to compare a pivot metric value in another column of different table and pickup the additional column jut like VLOOKUP