topic How to convert excel formula to qlik in App Development

How to convert excel formula to qlik

gp_123 — Thu, 25 Aug 2022 08:07:31 GMT

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.

Re: How to convert excel formula to qlik

gp_123 — Thu, 25 Aug 2022 10:05:11 GMT

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

Re: How to convert excel formula to qlik

Digvijay_Singh — Thu, 25 Aug 2022 16:37:40 GMT

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

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

Re: How to convert excel formula to qlik

deepanshuSh — Thu, 25 Aug 2022 16:54:39 GMT

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.

Re: How to convert excel formula to qlik

Masajnik — Fri, 26 Aug 2022 14:02:24 GMT

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?