How to convert excel formula to qlik

[gp_123]

Hi Everyone,
I want to convert below excel formula's in Qlik. 
PFA excels,

1.Formula(Column AW) : 
IFERROR(VLOOKUP(CONCATENATE($A3,"Assigned",2),Tasks!$A:$H,8,0)," ")

2.Formula(Column BB) : 
SUMIF(Tasks!$C:$C,Requests!#REF!,Tasks!$K:$K)

Please let me know if anyone having any idea.

Thanks in Advance.

[gp_123]

Hi @justISO,
I am again stuck at the mentioned excel formulas, Please help me if you have any idea?

[Digvijay_Singh]

Not sure if you saw this post, could be helpful - 

https://community.qlik.com/t5/QlikView-App-Dev/VLookup/td-p/1068404

[deepanshuSh]

I am not sure what exactly you are trying to do here, but for the VLOOKUP you can refer to the lookup function as mentioned by Digvijay above or look for Applymap and link table for getting the values for the same.

Also, I understand the if error functionality provides the result of that computation, if there is any error in the same, then it gives an error, which you can achieve by simply using if and else function here, like if (sum(sales)>0 , Sum(sales), 'Error'. 

For the second part you can simply use the if and else function. 

[Masajnik]

Hello, how are you? You can do it with a Mapping or join, generating an excel that has the same functions on the Qlik side, but I understand that the problem is that it does not retrieve the data from Excel with the formula, in that case , Is the one with the formulas a static file?