Add calculated field in a table that look string in a fiel (Column)

Davy — Fri, 24 Jan 2020 15:15:36 GMT

Dear all,

I am new with Qlik Sense and I want to ask you for an issue that I have.

I have loaded a table in Qlik and I want to add a calculated column (Add field).

The expression should:

If SySStatus = “TSCO” OR “TSOS”

then

lookup Noti&”_QMAR_”&Task Or Noti&”_QMAR_”&Task

Lookup in Offer

if found returns SySStatus

If not returns Empty

Else

Returns Empty

Which should be the expression in Qlik to do it?

Thanks

Re: Add calculated field in a table that look string in a fiel (Column)

Prashant_Naik — Sat, 25 Jan 2020 06:02:46 GMT

Hi Davy,

I am little confuse in requirement,

can you please explain more about the lookup that you want to do.

For the time being your can try ApplyMap() function of Qlik.

Load the Offer field in Mapping table and put the condition in main table as

If(wildmatch(SysStatus,'TSCO','TSOS'),Applymap('mapping Table name',Field Name or Expression),'Empty') as NewField;

For your reference to understand the working of Apply Map function.

Regards,

Prashant