topic Re: Replicating excel formula in Qlik in QlikView

Replicating excel formula in Qlik

pawwy1415 — Thu, 30 Nov 2017 15:14:17 GMT

Hi,

Overall Incidents (Column AJ) 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

Thanks

Re: Replicating excel formula in Qlik

Anil_Babu_Samineni — Thu, 30 Nov 2017 15:21:56 GMT

Re: Replicating excel formula in Qlik

pawwy1415 — Thu, 30 Nov 2017 15:46:44 GMT

This is the formula used in excel.. how we can replicate same in qlik

=IF(AK7>1,"R",IF(AK7=1,"A",IF(AL7>9,"R",IF(AL7>5,"A",IF(AR7>3,"R",IF(AR7>1,"A",IF(AP7+AQ7+AR7>3,"A","G")))))))