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

[Davy]

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

[Prashant_Naik]

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