Re: Replicating Excel formula in Qlik Sense - Qlik Community

pawwy1415 · ‎2017-11-30

Hi,

Overall RAG is calculated column in Excel, below formula is used in excel to calculate this.Could you please help how we can replicate this in Qlik Sense

=IF(OR(G7>0, H7>2),"R", IF(H7>1,"A","G"))

Anil_Babu_Samineni · ‎2017-11-30

May be this?

If(G7>0 or H7>2, 'R', If(H7>1,'A',G'))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

pawwy1415 · ‎2017-11-30

Is it front end or in backend?

Anil_Babu_Samineni · ‎2017-11-30

Anywhere

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

pawwy1415 · ‎2017-11-30

Could you please create example in excel and send to me?

Anil_Babu_Samineni · ‎2017-11-30

Not sure, What are you going to have from my end.

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful